RadSpreadProcessing is part of the Telerik Document Processing libraries. The full documentation for this component is available at https://docs.telerik.com/devtools/document-processing/libraries/radspreadsprocessing.
This library enables you to work with spreadsheet documents – create ones from scratch, modify existing documents or convert between the most common spreadsheet formats. You can save the generated workbook to a local file, stream, or stream it to the client browser.
RadSpreadProcessing comes with support for:
Shapes and Images: API for insertion, positioning and deletion of images in worksheets.
Hyperlinks: The API enables you to add, remove, edit and search for hyperlinks in the worksheets of the document.
Workbook Protection: Prevents the users from modifying the workbook by adding, removing, renaming or reordering sheets.
Worksheet protection: Restricts the user from modifying the content and structure of the worksheet. Additionally, the model offers protection options that let you choose a set of commands that will be available to the user when protection is enabled.
Grouping: Helps you organize data in sections, to be able to show and hide the currently relevant chunks.
Formulas: The library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.
Named ranges: You can use the named ranges on workbook and worksheet levels.
Styling: You can apply styles to the cells. The API allows you to duplicate one of the predefined styles or create a new one according to your preferences.
Theming: The document model comes with predefined themes called Document themes. They enable you to specify colors, fonts and a variety of graphic effects in a document and affect the look and feel of the whole workbook.
Resizing: Auto fit or resize rows and columns.
Number Formats: Enable you to format the data in the cells so it can be easily readable.
Data Validation: Enables you to control the type of data or the values that users enter into a cell. Different data validation rules are available, including list, number, date, text length or custom rules.
Filtering worksheet data.
Sorting the data in the worksheet.
Freeze Panes: Keep part of the worksheet visible at all times when scrolling.
Hidden rows and columns: The API of the workbook model allows you to set the hidden state of each row or column.
Merge and unmerge cells: You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
Page Setup: Set and get header and footer settings and apply various page setup options like paper size, orientation, scaling, margins, breaks, etc. Apply print settings.
History: The document model provides the possibility to maintain a history stack that tracks all changes to the content of the workbook. Each worksheet has its own history stack.
You have two options to add the required Telerik references to your Xamarin.Forms app in order to use RadSpreadProcessing:
- Add the Telerik UI for Xamarin Nuget package following the instructions in Telerik NuGet package server topic.
If you don't want to add the all Telerik.UI.for.Xamarin nuget package, you have the option to add a separate nuget package. For RadSpreadProcessing you have to install the Telerik.Documents.Core and Telerik.Documents.Spreadsheet nuget packages. The following nugets are required in order to be able to export to XLSX, XLS and PDF formats: Telerik.Documents.Spreadsheet.FormatProviders.OpenXml,Telerik.Documents.Spreadsheet.FormatProviders.Xls, Telerik.Documents.Fixed, Telerik.Documents.Spreadsheet.FormatProviders.Pdf, Telerik.Zip.
Add the references to Telerik assemblies manually, check the list below with the required assemblies for RadSpreadProcessing:
The following assemblies are required in order to be able to export to XLSX, XLS and PDF formats:
Please keep in mind these assemblies are located in the Portable folder, still, you need to add a reference to them in the Xamarin.Forms project as well as in each of the platform projects (Android | iOS | UWP).