Overview
Telerik SpreadProcessing Library allows you to generate and convert documents to XLSX, CSV, TXT, and PDF. RadSpreadProcessing ships with built-in support for the computation of more than 200 functions, like SUM, AVERAGE, and more. You can create spreadsheets 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.
The RadSpreadProcessing is part of Telerik Document Processing, a
professional grade .NET library for creating and manipulating PDF, Word, XLSX and HTML files. To try it out sign up for a free 30-day trial.
In this article, we list the library's most popular features. If you want to start using the library right away, see Getting Started with RadSpreadProcessing.
If you still don't have Telerik Document Processing installed, check the First Steps topic to learn how to obtain the packages through the different suites with Telerik controls.
Key Features
- Create from scratch and modify existing documents from spreadsheet formats: XLSX, CSV.
- Export to PDF.
- Convert between the different formats.
- Extracting and populating cells with data.
- Built-in support for computation of more than 200 functions, like SUM, AVERAGE, etc.
- Custom functions could be added as well.
- Protection from editing operations using passwords/removing such passwords.
- Most of the important Excel features are supported:
- Data validation - restrict the types of input to cells (e.g. allow only numbers).
- Grouping to organize data (e.g. collapse some rows/columns).
- Filtering, sorting, freeze panes, hidden rows, and more.
The following table describes the most popular features of the RadSpreadProcessing library.
| Feature | Description |
|---|---|
| Shapes and Images | API for insertion, positioning and deletion of images in worksheets. As of Q3 2024 RadSpreadProcessing provides support for SVG (vector graphics image format). |
| Charts | Add, remove and manipulate chart objects in your spreadsheet documents. |
| Conditional Formatting | Make it easy to analyze data, find critical issues, patterns and trends by representing the data inside in a user-friendly manner. |
| 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. The document model exposes the following categories of predefined formats: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and also allows you to create custom formats. |
| Copy/Paste | Add or copy worksheets within or across workbooks. Of course, copying and pasting of cells is supported as well. |
| 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 | Filter worksheet data. |
| Sorting | Sort data in the worksheet. |
| Find and replace data. | Find, find all, replace and replace all functionalities |
| 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. |
| Auto fill and Series | Fill cells automatically with data following a specific pattern. |
| Page Setup | Set and get header and footer settings and apply various page setup options like paper size, orientation, automatic 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. |
| Comments | You can leave comments and replies on cells, which allows for easier team communication. |
| Notes | Note important information in your worksheet. |
Supported formats
*This documentation is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.