ASP.NET AJAX SpreadProcessing

SpreadProcessing for ASP.NET AJAX is a document processing library that enables you to create spreadsheet documents, modify existing ones or convert between the most common spreadsheet formats. You can save the generated workbook to a local file, or stream it to the client browser.

The library closely follows the established document standard, defined in the Office Open XML specification, enables you to use C# and VB.NET and supports .NET Framework, .NET Core and .NET Standard. 

Documentation of the Telerik SpreadProcessing Library

The Telerik ASP.NET AJAX SpreadProcessing library is completely independent from external libraries or UI. You don’t need Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server to process Microsoft Excel documents.

The Telerik SpreadProcessing library supports the most common 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.

Documentation on the supported import and export formats of RadSpreadProcessing

Workbooks, or spreadsheet documents, contain one or multiple worksheets. Worksheets represent a collection of cells organized in rows and columns. The ASP.NET AJAX SpreadProcessing library features a rich API for configuring both the workbook and worksheet settings, such as theme, named ranges, protection, as well as rows and columns access.

Documentation on Workbooks and Worksheets in RadSpreadProcessing

The API of the workbook model allows you to control different row and column parameters. You can manually set their width and height. Alternatively, you can utilize the AutoFit functionality, which will automatically calculate the size of the rows and columns based on their contents. You also have the option to set the visibility properties, allowing users to hide rows and columns in the spreadsheet.

Documentation on Rows and Columns in RadSpreadProcessing

Cells are the core data unit of worksheets. The SpreadProcessing API features multiple options for working with cells, such as defining their value and changing their properties. You can format the cell fill, border, font, wrapping, number format, text rotation indentation and many more attributes. Predefined cell value types are available for you to conveniently handle any type of data.

Documentation on how to work with Cells in RadSpreadProcessing

The ASP.NET AJAX SpreadProcessing library supports predefined number formats which can be applied to cell values in the spreadsheet. The available formats include Number, Currency, Date, Time, Text, as well as custom formats.

Documentation on how to work with Number Formats in RadSpreadProcessing

Formulas are expressions calculating the value of a cell in the spreadsheet. The ASP.NET AJAX SpreadProcessing library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.

Documentation on how to work with Formulas in RadSpreadProcessing

You can insert, position and delete images in worksheets through a dedicated API.

Documentation on Shapes and Images support in RadSpreadProcessing

Add charts to spreadsheet documents to help users better understand data. ASP.NET AJAX SpreadProcessing supports various chart types, including Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area as well as combined charts or different series.

Documentation on Charts support in RadSpreadProcessing

Hyperlinks help users jump to sections of the workbook, open a local file or access a website address. You can add, remove, edit and search for hyperlinks in the worksheets of the document.

Documentation on Hyperlinks support in RadSpreadProcessing

Named ranges are collections of cells that can be easily accessed by the name they’ve been given. Handy when you need to reuse a reference to the same range of cells or you want to provide users with easy access to a predefined range of cells they can incorporate in formulas. You can use the named ranges on workbook and worksheet levels.

Documentation on Names and Named Ranges in RadSpreadProcessing

Freeze panes is a useful feature allowing part of the worksheet to always stay visible as users are scrolling. The API allows freezing any number of rows and columns.

Documentation on Freezing Panes in RadSpreadProcessing

Users can group rows or columns in sections that ca be expanded and collapsed—a handy way to hide the details and present just the summary of the worksheet data, while still keeping the underlying information available to see.

Documentation on Grouping support in RadSpreadProcessing

Filtering in ASP.NET AJAX SpreadProcessing allows you to set standard filters in worksheets and use custom logic for advanced operations. Out of the box, you can leverage our built-in functionality to filter data by certain values or range of values, find top or bottom, above or below average values and narrow down data for a certain period of time, such as last month and last quarter. You can also use Fill and ForeColor filters to filter for specific cell and font colors.

Documentation on Filtering support in RadSpreadProcessing

You can create and modify sorting rules and apply them to 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.

Documentation on Sorting support in RadSpreadProcessing

The autofill feature enables you to automatically populate worksheet cells with data following a specific pattern. You can set cell values to duplicate another cell’s value or apply algorithms for linear, linear trend, exponential, exponential trend sequences and date series.

Documentation on AutoFill and Series support in RadSpreadProcessing

Data validation enables you to specify the type of data or value users can enter in a cell. You can limit characters, set a time range, define a list of values, allow only whole numbers, allow only time or use formulas to customize rules.

Documentation on Data Validation support in RadSpreadProcessing

The Find and Replace APIs enable you to find and replace text and numbers in the spreadsheet document. You can define what to search, where in the document to search it and how to treat edge cases, such as whether to use a formula or the result value, match case, return single or multiple occurrences. The Replace API allows replacing the matches from the search with a desired value.

Documentation on how to use Find and Replace in RadSpreadProcessing

You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.

Documentation on how to merge and unmerge cells with RadSpreadProcessing

Page Setup lets you set the layout and print options of a page. You can control header and footer settings, paper size, orientation, margins, breaks and scaling options to fit rows and columns on a single page, plus many more.

Documentation on how to setup a page for printing with RadSpreadProcessing

Add or copy worksheets, cells and cell ranges within or across workbooks. You can fine-tune the appearance of the pasted content by specifying formatting options like paste values, formulas, control number and visual formatting and more.

Documentation on the Clipboard support in RadSpreadProcessing

You can protect the structure of your workbook so that users cannot add, remove, rename or reorder sheets.

Documentation on Workbook Protection in RadSpreadProcessing

You can protect every single worksheet in your workbook and prevent content from being edited. The model offers protection options that let you choose a set of commands that will be available to the user when protection is enabled.

Documentation on Worksheet Protection in RadSpreadProcessing

You can use styling to uniformly and simultaneously format cell fonts and font sizes, cell borders, alignment and more properties. You can choose to duplicate a predefined style or create a custom one.

Documentation on Cell Styling and Document Themes in RadSpreadProcessing

The ASP.NET AJAX SpreadProcessing library is fully compliant with the Federal Information Processing Standards (FIPS), enabling you to create documents that conform to the FIPS 140-2 standard.

Documentation on RadSpreadProcessing FIPS Compliance

You can customize the appearance of a workbook with themes. ASP.NET AJAX SpreadProcessing includes predefined themes, called Document themes, which allow you to set the colors, fonts and a variety of graphic effects of the workbook.

Documentation on the supported Document Themes in RadSpreadProcessing