SpreadStreamProcessing is a high-performance spreadsheet document library that enables you to create and export large XLSX and CSV spreadsheet documents using less computing resources and minimal memory. Enjoy high-performance spreadsheets that can handle massive amounts of data with ease.
The SpreadStreamProcessing library exposes an API for creating worksheets in a workbook and adding rows and cells in the worksheets. The worksheet API features options for controlling the first visible cell, the selected cells, the gridlines visibility, the row and column header and zoom level.
Cells are the basic unit of data in worksheets - they are the intersection point of rows and columns. The SpreadStreamProcessing Library API provides multiple properties for defining the value and formatting options of cells. You can apply different settings for fill, border, font family and size, wrapping, as well as use various format strings, making it easy to work with different types of data.
In addition to setting the various cell properties when creating cells in a worksheet, the cell value can also be set to any formula supported by the OpenXML format. This will guarantee that when the document is open in any spreadsheet application complying with this format, the formulas will be appropriately evaluated.
A cell style is a predefined set of formatting options such as border options, fonts and format strings, that allows you to reuse it across the whole document during cell creation. In this way you can ensure consistency in cell appearance across your spreadsheets.
When creating the cells, you have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.