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.
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.
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.
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.
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.
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.
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.
You can insert, position and delete images in worksheets through a dedicated API.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
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.
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.
You can protect the structure of your workbook so that users cannot add, remove, rename or reorder sheets.
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.
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.
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.
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.