ASP.NET MVC SpreadProcessing

SpreadProcessing 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.

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 MVC SpreadProcessing library has no dependencies on external libraries or UI. Process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server.

Popular spreadsheet file extensions and formats, including XLSX (Excel Workbook), XLS (Excel 97-2003 Workbook), CSV, plain text and PDF (export only), are all supported in the Telerik SpreadProcessing library. 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, alternatively named spreadsheet documents, contain one or several worksheets, where you can organize data in cells. The powerful API of SpreadProcessing for ASP.NET MVC enables you to configure both the workbook and worksheet settings, including theme, named ranges, protection, as well as rows and columns access.

Documentation on Workbooks and Worksheets in RadSpreadProcessing

The workbook model API allows you to modify rows and columns in the spreadsheet. You can choose to manually define their height and width, respectively, or enable AutoFit to let the program automatically calculate the rows and columns size based on their contents. You can additionally set the visibility properties, allowing users to hide rows and columns.

Documentation on Rows and Columns in RadSpreadProcessing

Cells are the essential data unit of worksheets. The ASP.NET MVC SpreadProcessing API offers all the industry-standard options to define cell values and formatting properties. You can enable users to modify the cell fill, border, font, wrapping, number format, text rotation indentation and many more attributes. Cell value types are available for you out of the box to conveniently handle any type of data.

Documentation on how to work with Cells in RadSpreadProcessing

Telerik SpreadProcessing supports predefined number formats that can be applied to cell values in the spreadsheet. You can format and display numbers, currencies, dates, time, text as well as custom value format.

Documentation on how to work with Number Formats in RadSpreadProcessing

Formulas calculate cell values using various functions. The SpreadProcessing API enables you to make use of more than 200 built-in functions and easily plug custom formulas whenever you need to.

Documentation on how to work with Formulas in RadSpreadProcessing

Through a dedicated API, you can insert, position and delete images in worksheets.

Documentation on Shapes and Images support in RadSpreadProcessing

Help users visualize data with the right chart type. SpreadProcessing enables you to add a large variety of charts to spreadsheet documents, including Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area as well as combined charts or different series.

Documentation on Charts support in RadSpreadProcessing

Hyperlinks are references users can follow to navigate to a section of the workbook, open a local file or access a URL. You can add, remove, edit and search for hyperlinks in the worksheets of the document.

Documentation on Hyperlinks support in RadSpreadProcessing

Named ranges are groups of cells that can be easily accessed by the name they’ve been assigned. Named ranges can make formulas easier to understand by replacing standard cell references and help users use the same range of cells multiple times in a document. You can use the named ranges on workbook and worksheet levels.

Documentation on Names and Named Ranges in RadSpreadProcessing

The Freeze panes features locks important rows and columns in place to never lose sight of their content as users scroll through the worksheet. The API allows freezing any number of rows and columns.

Documentation on Freezing Panes in RadSpreadProcessing

The SpreadProcessing grouping feature helps users more easily read and summarize data by organizing it in sections. Group rows or columns to show only relevant chunks of information and collapse what you currently don’t need in view.

Documentation on Grouping support in RadSpreadProcessing

Filtering in ASP.NET MVC SpreadProcessing allows you to set standard and custom filters in worksheets. The available filter options include filtering by certain values or range of values, by time period such last month and last quarter or using predefined filters such as Top, Bottom, Above Average, Fill and ForeColor.

Documentation on Filtering support in RadSpreadProcessing

You can define, modify and apply sorting rules in worksheets to organize data in particular ways. Sorting can be specified in ascending and descending order, by Fill and ForeColor values as well as with custom sorting logic.

Documentation on Sorting support in RadSpreadProcessing

Through the SpreadProcessing API, you can automatically fill cells with data following a specific model. Supported autofill patterns include repeating cell values and increasing, decreasing or multiplying the value by a predefined step with algorithms, including linear, linear trend, exponential, exponential trend and date series.

Documentation on AutoFill and Series support in RadSpreadProcessing

Create validation rules that control the type of data input of specific cells. You can allow only particular data types such as numbers, time and dates, restrict text length, predefine values for a dropdown or specify a custom data entry with formulas.

Documentation on Data Validation support in RadSpreadProcessing

The Find and Replace function enables you to search text and numbers in the spreadsheet document and replace them with a new value. The Find API helps you define what to search, where in the document and how to treat formulas, case differences and multiple occurrences. The Replace API allows substituting 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 worksheet. You can control header and footer settings, paper size, orientation, margins, breaks, 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

Workbook protection forbids users to add, remove, rename or reorder sheets in the workbook.

Documentation on Workbook Protection in RadSpreadProcessing

Lock cells and other elements to limit changes to the worksheet content and structure, with and without a password. You can selectively allow users to perform certain actions like edit cells, insert and delete columns, insert and delete rows or disable them altogether.

Documentation on Worksheet Protection in RadSpreadProcessing

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

Documentation on Cell Styling and Document Themes in RadSpreadProcessing

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

Documentation on RadSpreadProcessing FIPS Compliance

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

Documentation on the supported Document Themes in RadSpreadProcessing