ASP.NET MVC SpreadStreamProcessing

SpreadStreamProcessing for ASP.NET MVC uses a document processing method that allows you to create and export big XLSX and CSV documents with great performance and minimal memory footprint. When data volume is hefty and speed is of utmost importance, SpreadStreamProcessing is your best choice.

Learn more about SpreadStreamProcessing and how it compares to SpreadProcessing

The document model is fully independent from third-party software or UI. Users can work with Microsoft Excel supported documents without the necessity to have Microsoft Excel, Microsoft Office or any other external library installed on the client or server.

Write spreadsheet content directly into a stream to optimize performance. The library will not create or save the document model in memory.

Leverage flexible API capabilities to create worksheets in a workbook and add rows and cells in the worksheets. The worksheet API enables you to control 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

Import worksheets from different documents into a new or existing workbook with the append feature in the ASP.NET MVC SpreadStreamProcessing library. With the help of the flexible API, you can get the appended worksheet names and avoid possible worksheet naming collisions.

When creating rows and columns, there is a convenient API that enables you to set the width and height, as well as the visibility of rows and columns. You can hide individual rows and columns that contain data you currently don’t need displayed.

Documentation on how to work with Rows and Columns in RadSpreadStreamProcessing

The grouping feature allows for restructuring of data in a worksheet by grouping rows and columns into sections. Users can expand and collapse grouped rows and columns of their choice to hide portions of the detailed data and present just the summary of it. Use the SpreadStreamProcessing API to set the outline level of rows/columns when creating them.

Cells are the basic units of data entry in a spreadsheet, containing and organizing data in a grid-like fashion. With the Telerik ASP.NET MVC SpreadStreamProcessing library, you are able to set the cell value and formatting options, such as fill, border, font family and size, wrapping, as well as various format strings to render the desired data type.

Documentation on how to work with Cells in RadSpreadStreamProcessing

SpreadStreamProcessing for ASP.NET MVC enables you to use any formula supported by the OpenXML format to set cell values. This will ensure the formulas are always evaluated correctly by any spreadsheet application that complies with this format.

Documentation on the Formulas support in RadSpreadStreamProcessing

Cell styles enables you to simultaneously format several cell properties, such as font, border, alignment and more to achieve a consistent cell appearance across your spreadsheet.

Documentation on how to Style Cells with RadSpreadStreamProcessing

You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.

Frozen panes allow you to scroll through your worksheet content while continuing to view the frozen rows and columns. The API allows freezing any number of rows and columns during their creation.