SpreadStreamProcessing for Xamarin is a high-performance library optimized for the creation of large spreadsheet documents with minimal memory footprint. You can also export the generated spreadsheets to XLSX and CSV file formats with the same performance excellency. The document library is designed to handle large volumes of data at light speed while using minimal memory to prevent common out-of-memory errors and re-drawing issues.
The document model works independently from external code or UI. The Xamarin SpreadStreamProcessing library doesn't require having Microsoft Excel, Microsoft Office or any other spreadsheet document library installed on the client or server to process Microsoft Excel supported documents.
The key to the memory efficiency of the SpreadStreamProcessing library is it writes the spreadsheet content directly to a stream without creating and preserving the spreadsheet document model in memory. Each time an exported object is disposed, the set values are written into the stream.
The SpreadStreamProcessing library for Xamarin exposes an API for creating worksheets, rows and cells in a workbook. Enjoy flexible options for customizing the worksheet view, such as changing the first visible cell, the selected cells, showing and hiding gridlines, adjusting the row and column header and zoom level and more.
You can easily import table data from one spreadsheet document to another by appending a worksheet into a new or existing workbook. Use the Telerik Xamarin SpreadStreamProcessing library API to get the appended worksheet names and avoid possible name errors.
Grouping is a quintessential spreadsheet feature that helps group rows and columns to structure data into sections. Users can easily expand or collapse entire parts of the worksheet to gain better insight into the data. Use the SpreadStreamProcessing for Xamarin API to set the outline level of rows/columns when creating them.
Cells are the basic unit, containing data in worksheets—they are the intersection point of rows and columns. The rich API of SpreadStreamProcessing for Xamarin comes with built-in properties to control the cell value and formatting options. You can apply different settings, such as cell fill, border, font family and size, wrapping, as well as format strings, making it easy to work with different types of data.
Next to the many cell properties available to you to format cells in the Xamarin SpreadStreamProcessing library, you can work with any OpenXML-supported formula to set the cell value. Whenever the document is open in a spreadsheet application complying with the format, the formulas will be calculated in the correct way.
Use styles to uniformly format cells across your entire spreadsheet. Simultaneously change cell properties like size, font, border, alignment and more to achieve a consistent cell appearance.
When creating cells in a spreadsheet, you can enable users to merge two or more adjacent cells into a single cell that spans over multiple rows and columns so they can more easily center headings, wrap text and outline data.