Progress Telerik UI for Blazor
SpreadStreamProcessing for Blazor is a document processing library that enables you to create large spreadsheet documents and export them to XLSX and CSV file formats with great performance and minimal memory footprint. The document library is designed to handle large volumes of data with high speed and minimal memory so you can avoid common out-of-memory errors and re-drawing issues.
The document model is entirely free from dependencies on external libraries or UI. Users can open and manage Microsoft Excel supported documents with no Microsoft Excel, Microsoft Office or any other spreadsheet processing library installed on the client or server.
The library dynamically writes the document content into a specified stream for memory efficiency. Each time an exported object is disposed, the set values are written into the stream. This allows you to create large documents with excellent performance.
Adding worksheets to a workbook and creating rows and cells in the worksheets can be easily done with the Blazor SpreadStreamProcessing library. The worksheet API exposes options to control the first visible cell, the selected cells, the gridlines visibility, the row and column header and zoom level.
You can easily load data from one spreadsheet document to another by appending worksheets into a new or existing workbook. Utilize the SpreadStreamProcessing library API to transfer the appended worksheet names and avoid possible worksheet name conflicts.
With the Blazor SpreadStreamProcessing, you can enable users to group rows or columns into sections to easily read, outline and compare data in a worksheet. Users can selectively expand or collapse grouped rows and columns of their choice to hide portions of the data and present only what they need in view. Use the SpreadStreamProcessing API to set the outline level of rows/columns when creating them.
Every worksheet is made up of cells, whose primary function is to contain and represent data. The SpreadStreamProcessing library for Blazor offers a plethora of options for defining the cell value and formatting capabilities. You can apply a number of settings, such as fill, border, font family and size, wrapping, as well as add format strings to help specify various data types.
Along with the various cell properties available to you, you have the ability to import any OpenXML-supported formula to set the cell value. In this way, you ensure that whenever the spreadsheet is open in an application complying with the format, the formulas will be evaluated correctly.
Styles help you achieve a consistent look and feel of cells across your entire worksheet by formatting multiple cell properties like border options, fonts and strings in one go. You can choose a pre-defined cell style from our library or create your own—save it, store it and reuse it.
The merge cells feature allows users to combine two or more adjacent cells into a single one to center headings, wrap text and outline data.
Lock rows and columns in place to never lose sight of their content as you scroll through your worksheet. The API allows freezing any number of rows and columns during their creation.