Blazor SpreadProcessing

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.

Documentation of the Telerik SpreadProcessing Library

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

Documentation on the supported import and export formats of RadSpreadProcessing

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.

Documentation on Workbooks and Worksheets in RadSpreadProcessing

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.

Documentation on Rows and Columns in RadSpreadProcessing

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.

Documentation on how to work with Cells in RadSpreadProcessing

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.

Documentation on how to work with Number Formats in RadSpreadProcessing

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.

Documentation on how to work with Formulas in RadSpreadProcessing

Insert, position and delete images in worksheets through a dedicated API.

Documentation on Shapes and Images support in RadSpreadProcessing

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.

Documentation on Hyperlinks support in RadSpreadProcessing

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.

Documentation on Names and Named Ranges in RadSpreadProcessing

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.

Documentation on Freezing Panes in RadSpreadProcessing

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.

Documentation on Grouping support in RadSpreadProcessing

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.

Documentation on Filtering support in RadSpreadProcessing

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.

Documentation on Sorting support in RadSpreadProcessing

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.

Documentation on AutoFill and Series support in RadSpreadProcessing

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.

Documentation on Data Validation support in RadSpreadProcessing

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.

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

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 allows you to maintain the structural integrity of your workbook by preventing users from adding, removing, renaming or reordering sheets.

Documentation on Workbook Protection in RadSpreadProcessing

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.

Documentation on Worksheet Protection in RadSpreadProcessing

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.

Documentation on Cell Styling and Document Themes in RadSpreadProcessing

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.

Documentation on RadSpreadProcessing FIPS Compliance

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.

Documentation on the supported Document Themes in RadSpreadProcessing