Progress Telerik UI for ASP.NET MVC
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.
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.
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.
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.
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.
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.
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
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.