ASP.NET AJAX SpreadStreamProcessing

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.

Learn more about SpreadStreamProcessing and how it compares to SpreadProcessing

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.

Documentation on how to work with Workbooks and Worksheets in RadSpreadStreamProcessing

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.

A convenient API will help you define row and column width, height and visibility while creating them in a workbook. You can hide individual rows and columns that you temporarily don’t need displayed.

Documentation on how to work with Rows and Columns in RadSpreadStreamProcessing

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.

Documentation on how to work with Cells in RadSpreadStreamProcessing

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.

Documentation on the Formulas support in RadSpreadStreamProcessing

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.

Documentation on how to Style Cells with RadSpreadStreamProcessing

Combine two or more adjacent cells into a single one that spans over multiple rows and columns.

Documentation on how to Merge Cells with RadSpreadStreamProcessing

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.