Xamarin.Forms SpreadStreamProcessing

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.

Learn more about SpreadStreamProcessing and how it compares to SpreadProcessing

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.

Documentation on how to work with Workbooks and Worksheets in RadSpreadStreamProcessing

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.

A convenient API allows you to control row and column width and height. You can additionally hide rows or columns you currently don’t need to see through the visibility property.

Documentation on how to work with Rows and Columns in RadSpreadStreamProcessing

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.

Documentation on how to work with Cells in RadSpreadStreamProcessing

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.

Documentation on the Formulas support in RadSpreadStreamProcessing

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.

Documentation on how to Style Cells with RadSpreadStreamProcessing