SpreadStreamProcessing for ASP.NET AJAX is a high-speed library for generating large spreadsheet documents and exporting them to XLSX and CSV file formats with optimal performance, minimal memory and less computing resources. When data volume and speed are critical for the success of your projects, SpreadStreamProcessing is your best choice.
The document model doesn’t depend on external libraries or UI. Users are able to process Microsoft Excel supported documents even without having Microsoft Excel, Microsoft Office or any other third-party software installed on the client or server.
Directly stream spreadsheet data to maximize performance. The library writes the spreadsheet content directly to a stream without saving the spreadsheet document model in memory.
The ASP.NET AJAX SpreadStreamProcessing library comes with a flexible API for creating rows, cells and worksheets in a workbook. The worksheet API features options for customizing the first visible cell, selected cells, gridlines visibility, row and column header and zoom level, as well as to freeze panes.
Easily combine multiple worksheets into a new or existing workbook with the high-performing SpreadStreamProcessing library. Utilize the API to copy the original worksheet names to avoid possible name duplications.
The grouping feature allows users to organize data in sections to keep what’s important in view and temporarily remove what distracts them. They can group and selectively expand/collapse rows and columns of their choice to hide portions of the data and present only the summary of it. Use the SpreadStreamProcessing API to set the outline level of rows and columns when creating them.
Cells are the building blocks of spreadsheets—they represent the intersection point of rows and columns. The ASP.NET AJAX SpreadStreamProcessing library enables you to define the cell value and formatting options. You can apply different settings for cell fill, border, font family and size, text wrapping, as well as format strings to accommodate existing data types.
In addition to the various cell properties available to you, you can set the cell value to any formula supported by the OpenXML format. When the document is open in any spreadsheet application that complies with this format, it will evaluate the formulas correctly.
Apply a consistent style to all cells across your worksheet. Using cell styles allows you to format multiple cell properties, including borders, fonts and strings, in one step. You can apply a predefined style or create a new one.
Combine two or more adjacent cells into a single one that spans over multiple rows and columns.
Freeze important rows and columns so you can see them no matter where you go in your worksheet. The API allows freezing any number of rows and columns during their creation.