Telerik SpreadProcessing Library is a document processing library that enables you to work with spreadsheet documents using C# and VB.NET. Create new 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.
The library closely follows the established document standard defined in the Office Open XML specification and supports .NET Framework, .NET Core and .NET Standard.
Documentation of the Telerik SpreadProcessing Library
The Telerik SpreadProcessing library supports the most frequently used spreadsheet formats—XLSX (Excel Workbook), XLS (Excel 97-2003 Workbook), CSV, plain text and PDF (export only). The API also enables you to easily convert DataTable objects into Worksheet and vice versa in case you need to work with data from a database.
Workbooks are an alternative name for spreadsheet documents. They contain one or more worksheets, where the actual cells in the spreadsheet live. The Telerik SpreadProcessing library features a rich API for manipulating both workbooks and worksheets with options such as setting the theme, named ranges, protection, as well as accessing the rows and columns.
Documentation on Workbooks and Worksheets in RadSpreadProcessing
The API of the workbook model allows you to manipulate row height and column width by setting them manually or by utilizing the AutoFit feature to automatically calculate the row and column size based on their contents. You can additionally set their visibility properties allowing to hide rows and columns in the spreadsheet.
Cells are the basic unit of data in worksheets—they are the intersecting point of rows and columns. The Telerik SpreadProcessing API features multiple options for formatting cells and defining their value, such as fill, border, font, wrapping, number format, text rotation indentation and many more. In addition, convenient predefined cell value types are available, making it easier to work with any type of data.
The SpreadProcessing library supports a vast array of predefined number formats that can be applied to cell values in the spreadsheet. The formats include Number, Currency, Date, Time, Text, as well as custom formats.
Formulas are expressions calculating the value of a cell in the spreadsheet. The Telerik SpreadProcessing library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.
You can insert, position and delete images in worksheets through a dedicated API.
Telerik SpreadProcessing provides the ability to add charts to spreadsheet documents. Help users better understand data with the right chart type. Supported charts include Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area, as well as combined charts or different series.
Hyperlinks help users quickly navigate to a specific part of the workbook, open a local file or website address. You can add, remove, edit and search for hyperlinks in the worksheets of the document.
Named ranges are collections of cells, which can be easily accessed by their name. Useful when need to refer multiple times to the same range of cells or you want to provide easy access to a predefined range of cells to the users to incorporate in formulas. You can use the named ranges on workbook and worksheet levels.
Freeze panes is a useful feature allowing part of the worksheet to remain visible at all times when users are scrolling. The API allows freezing any number of rows and columns.
The SpreadProcessing grouping feature allows to place rows and/or columns in sections, which could be expanded and collapsed by the users. Quite useful, when we want to hide the complexity of the detailed data and present just the summary of it, while still keeping it available for users.
The filtering functionality of the Telerik SpreadProcessing library allows setting predefined filters in the resulted document worksheets. The available filter options include filtering by certain values or range of values, for certain period of time and using predefined filters such as Top or Bottom, Above Average and Fill and ForeColor. The library also supports custom logic for advanced filtering of spreadsheet data.
The sorting feature allows to create and modify sorting rules in worksheets, resulting in sort rules applied to the needed parts of the spreadsheet. Sorting can be specified using ascending and descending order of the cell values, Fill and ForeColor values as well as with custom sorting logic.
With the auto filling functionality, the SpreadProcessing API enables filling cells automatically with data following a specific pattern. The supported patterns include repeating cell values or applying the following algorithms: linear, linear trend, exponential, exponential trend and date series.
Gives you control over the type of data or values users can enter into a cell. You can define different data validation rules about required value, lists, numbers, dates, text length or custom values.
The Find and Replace APIs provides the ability to find an replace text and numbers in the spreadsheet document. The highly customizable Find functionality allows you to define what to search, where in the document to search it and how to treat subtleties like case-sensitive data, single and multiple occurrences and whether to return the formula or the result value. The Replace API allows replacing the find results with a desired value.
You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
Page Setup allows controlling how the worksheet will look when printed or exported to PDF. Set and get header and footer settings and apply various page setup options like paper size, orientation, scaling, margins, breaks, options how to fit rows and columns on a single page and many more.
You can add or copy worksheets, cells and cell ranges within or across workbooks. Fine-tune the formatting of the pasted content by specifying options like paste values, formulas, control number and visual formatting and more.
Workbook protection prevents changes to your workbook structure. You can restrict editing so users cannot add, remove, rename or reorder sheets.
Worksheet protection helps you maintain control over the worksheet data and structure and ensures that users cannot change it. The worksheet protection options allow you to select what types of actions will be available to users, to which cell ranges the protection will apply to. You can protect worksheets with or without a password.
Apply the same formatting style to cells across your workbook. Choose from the Telerik SpreadProcessing built-in styles or create a new one to format cell colors, fonts and font sizes, borders, alignment, format and more.
Unify the look of your workbook with out-of-the-box spreadsheet Document themes. Set the colors, fonts and a variety of graphic effects and apply consistent formatting to the entire document by utilizing the predefined themes or creating one of your own.