SpreadProcessing

RadSpreadProcessing for ASP.NET MVC is a document processing library that enables you to work with spreadsheet documents—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, a stream, or stream it to the client browser.

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

Allows you to disable modifications to the workbook structure. Users cannot add, remove, rename or reorder sheets.

Worksheet Protection

Enables you to protect the content and structure of your worksheet. From the protection options, you can selectively allow or restrict users to make changes like edit cells, insert and delete columns and insert and delete rows.

Grouping

Helps you more easily read and summarize data by organizing it in sections. Group rows and columns to show relevant chunks and hide what you currently don’t need in view.

Formulas

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.

Named Ranges

You can use the named ranges on workbook and worksheet levels.

Styling

Ensures cell formatting consistency. Styling applies a set of formatting characteristics, such as font size, border, alignment and more, to a cell in one go. You can choose to apply a built-in style or create your own.

Theming

The document model offers several predefined themes called Document themes. Each theme enables you to specify the colors, fonts and a variety of graphic effects that apply to the appearance of the whole workbook.

Resizing

Autofit or resize rows and columns.

Number Formats

Apply the correct format to numbers in cells—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

Helps you ensure data quality and data accuracy by controlling the type of data or value users are allowed to enter into a cell. You can specify rules for text length, numbers and dates, predefine values for dropdown lists or customize a condition with formulas.

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

SpreadProcessing for  ASP.NET MVC enables your apps to easily import and export files to and from the most common spreadsheet file formats including:

• Excel Microsoft Office Open XML Spreadsheet (.XLSX)
• Comma separated values (.CSV)
• Tab separated values (.TXT)
• Portable document format (.PDF) (export only)