RadSpreadProcessing 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, stream, or stream it to the client browser.
You can insert, position and delete images in worksheets through a dedicated API.
You can add, remove, edit and search for hyperlinks in the worksheets of the document.
You can protect the structure of your workbook so that users cannot add, remove, rename or reorder sheets.
You can lock the content and structure of your worksheet to limit the types of modifications users can make. You can specify the commands available to users when protection is enabled.
Organizes data in sections. You can group rows or columns to make data easier to read, keep what you need in view and collapse what distracts you.
Formulas are expressions calculating the value of a cell in the spreadsheet. The RadSpreadProcessing library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.
You can use the named ranges on workbook and worksheet levels.
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.
You can customize the appearance of a workbook with themes. Telerik RadSpreadProcessing includes predefined themes, called Document themes, which allow you to set the colors, fonts and a variety of graphic effects of the workbook.
Autofit or resize rows and columns.
Apply the correct format to numbers in cells—currency, percentages, decimals, dates, phone numbers and more.
Add or copy worksheets within or across workbooks. Of course, copy and paste of cells is supported as well.
You can 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.
Filtering worksheet data.
Sorting the data in the worksheet.
Find and replace data.
Keep part of the worksheet visible at all times when scrolling.
The API of the workbook model allows you to set the hidden state of each row or column.
You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
Fill cells automatically with data following a specific pattern.
Set and get header and footer settings and apply various page setup options like paper size, orientation, scaling, margins, breaks, etc. Apply print settings.
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.
The library supports the most frequently used spreadsheet formats—plain text, XLSX, CSV and PDF (export only).