Progress Telerik UI for ASP.NET MVC
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.
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.
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.
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.
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.
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.
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.
Through a dedicated API, you can insert, position and delete images in worksheets.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
Workbook protection forbids users to add, remove, rename or reorder sheets in the workbook.
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.
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.
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.
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.