The Telerik Blazor SpreadProcessing 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 or stream, or stream it to the client browser. The library model allows you to employ C# and VB.NET, closely follows the established document standard, defined in the Office Open XML specification, and supports .NET Framework, .NET Core and .NET Standard.
SpreadProcessing for Blazor has no external dependencies on third-party libraries or UI. Process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server.
Telerik SpreadProcessing offers full support for the most frequently used spreadsheet file extensions and formats, including XLSX (Excel Workbook), XLS (Excel 97-2003 Workbook), CSV, plain text and PDF (export only). 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
Spreadsheet documents, sometimes called simply workbooks, contain a single or a collection of worksheets, where data is housed and processed. The Blazor SpreadProcessing library provides a powerful API for setting multiple workbooks and worksheet properties, such as theme, named ranges, protection, as well as controlling rows and columns access.
The API of the workbook model lets you manipulate spreadsheet rows and columns. The column width and row height can be defined either manually or automatically with the help of AutoFit functionality, which will automatically resize the rows and columns to fit their contents. Additionally, the hidden state of each row or column can be set to allow users to hide certain rows and columns in the spreadsheet.
Cells represent the basic unit to manipulate data in worksheets. The SpreadProcessing API features a wide range of options for working with cells, including setting their values and properties. Enable formatting the cell fill, border, font, wrapping, number format, text rotation indentation and many more attributes. Predefined cell value types are available for you out of the box to conveniently handle any type of data.
You can apply number formats to cells in a spreadsheet to display numerical values in your desired format. The SpreadProcessing library supports predefined number formats, including Number, Currency, Date, Time, Text, as well as custom formats.
Formulas are expressions that allow users to calculate the value of a cell in the spreadsheet based on other cell values. The SpreadProcessing library provides you with more than 200 built-in functions and the API enables you to easily plug custom formulas when you need to.
Insert, position and delete images in worksheets through a dedicated API.
Hyperlinks are links inside the workbook that take users to a location within the document, open a local file or an external website URL. You can add, remove, edit and search for hyperlinks in the worksheets of the document.
Named ranges are groups of cells that are given a name for quick access. They are useful when you need to reuse a reference to the same cell range or you want to enable users to incorporate a predefined range of cells in formulas. Named ranges can be used on both workbook and worksheet levels.
Frozen panes allow users to keep an area of a worksheet always visible while scrolling to another area of the worksheet. You can freeze any number of rows and columns. The API allows freezing any number of rows and columns.
SpreadProcessing helps users more easily read and summarize data by organizing it in sections. With the grouping feature, you can combine rows or columns to show relevant chunks of information or compare data and collapse what you currently don’t need in view.
The filtering functionality of SpreadProcessing for Blazor supports setting predefined and custom filters in worksheets. The filtering options allow filtering data by certain values or value ranges, by time and date, by top, bottom and average values and cell ad font colors. You can additionally utilize custom logic to build your own filters.
The sorting feature allows to specify and change rules for sorting data in different parts of the spreadsheet. Sorting can be defined using the ascending and descending order of the cell values, Fill and ForeColor values or with custom criteria by replacing the default logic with your own sorting logic.
You can automatically fill worksheet cells with data based on values in other cells or based on a specific model. The SpreadProcessing API supports repetitive and incremental autofill patterns, such as repeat cell value, linear, linear trend, exponential, exponential trend and date series.
Maintain data consistency by making sure users enter pre-defined types of data or values into a cell. You can for example limit text characters, set a time range, define a list of values, allow only whole numbers, allow only time or use formulas to customize the rules.
The SpreadProcessing API enables you to substitute text and numbers in the spreadsheet document. You can define the search terms and values, where in the document to search them and how to treat ambiguous matches, such as formulas behind numeric values, different cases and multiple occurrences. The Replace API allows replacing the returned values with a new one.
You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
Page setup allows users to adjust the size and layout of a worksheet before printing or export it. They can control header and footer settings, paper size, orientation, margins, breaks, scaling options for fitting rows and columns on a single page and 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 allows you to maintain the structural integrity of your workbook by preventing users from adding, removing, renaming or reordering sheets.
Forbid users to edit the content or modify the structure of the worksheet. The library model offers protection options that allow you to selectively switch on and off certain commands available to users when protection is enabled.
Bulk-format cells with styles to achieve consistent cell formatting across your workbook. Use a built-in library style or create a new one to set cell fonts, colors and font sizes, borders, alignment and more.
The Blazor SpreadProcessing library is compliant with the Federal Information Processing Standards (FIPS) and you can create documents that fully conform to the FIPS 140-2 standard.
Document themes enable you to achieve a consistent appearance of your workbook. Use the predefined SpreadProcessing Document themes to specify the colors, fonts and a variety of graphic effects of the document, or create your own.