WPF SpreadStreamProcessing

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.

Learn more about SpreadStreamProcessing and how it compares to SpreadProcessing

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.

Documentation on how to work with Workbooks and Worksheets in RadSpreadStreamProcessing

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.

When creating rows and columns, there is convenient API for setting the width and height, as well as the visibility (hide or unhide) of individual or multiple (grouped) rows and columns.

Documentation on how to work with Rows and Columns in RadSpreadStreamProcessing

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.

Documentation on how to work with Cells in RadSpreadStreamProcessing

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.

Documentation on the Formulas support in RadSpreadStreamProcessing

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.

Documentation on how to Style Cells with RadSpreadStreamProcessing

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.

Documentation on how to Merge Cells with RadSpreadStreamProcessing

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.