SpreadProcessing

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

See Demo of the ASP.NET Core SpreadProcessing Library

Shapes and Images

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

Hyperlinks

You can add, remove, edit and search for hyperlinks in the worksheets of the document.

Workbook Protection

Forbids users to add, remove, rename or reorder sheets in the workbook.

Worksheet Protection

Forbids users to edit the content or modify the structure of the worksheet. The library model offers protection options that allow you to selectively disable or enable certain commands for users when protection is enabled.

Grouping

Make you data more manageable. Collapse or expand grouped parts of your worksheet to focus on the information you need.

Formulas

The library comes with more than 200 built-in functions which cover a wide spectrum of categories including:

• Financial formulas
• Statistical formulas
• Engineering formulas

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

Styling allows you to apply predefined or custom formatting to cells. You can format cell fonts and font sizes, borders, alignment and more in one step and achieve a uniform look.

Theming

Themes affect the look and feel of a workbook. Telerik RadSpreadProcessing includes predefined themes that enable you to set the colors, fonts and a variety of graphic effects of the entire workbook.

Resizing

Autofit or resize rows and columns.

Number Formats

Display numbers in the correct format —currency, percentages, decimals, dates, phone numbers and more.

Copy/Paste

Add or copy worksheets within or across workbooks. Of course, copy and paste of cells is supported as well.

Data Validation

Enables you to control user input. Data validation ensures that users enter a type of data or values that comply with certain rules you set for number, date, text length, list values or custom input.

Filtering

Filtering worksheet data.

Sorting

Sorting the data in the worksheet.

Find and Replace

Find and replace data.

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.

Autofill 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, 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.

Supported Formats

The library supports the most frequently used spreadsheet formats—plain text, XLSX, CSV and PDF (export only).