SpreadStreamProcessing for WPF 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 document model has no external dependencies on third-party software or UI. Users are able to process Microsoft Excel supported documents even without having Microsoft Excel, Microsoft Office or any other external 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.
The WPF 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.
Easily append new worksheets to a new or existing workbook with the high-performing SpreadStreamProcessing library. Utilize the API to get the appended worksheet names in order to avoid possible collisions in worksheet naming.
The WPF SpreadStreamProcessing grouping feature allows placing rows and/or columns in sections which could be expanded and collapsed by users—quite useful when we want to hide the complexity of the detailed data and present just the summary of it, while still keeping it available for users to see. Use the SpreadStreamProcessing API to set the outline level of rows/columns when creating them.
Cells are the basic unit of data in worksheets—they are the intersection point of rows and columns. The SpreadStreamProcessing for WPF 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.
Freeze panes is a useful feature allowing part of the worksheet to remain visible at all times when users are scrolling. The API allows freezing any number of rows and columns during their creation.