The Telerik .NET MAUI SpreadProcessing is a document processing library that empowers you to work with spreadsheet documents - create new documents from scratch, modify existing ones or convert between the most common spreadsheet formats. You are able to save the generated workbook to a local file, stream, or even stream it to the client browser. The library model allows you to utilize C# and VB.NET, follows the established document standard, defined in the Office Open XML specification and supports .NET Standard, .NET Framework and .NET Core and
Telerik SpreadProcessing for .NET MAUI is completely independent of external libraries or UI. You are able to process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any third-party spreadsheet software installed on the client or server.
Telerik SpreadProcessing library fully supports common spreadsheet file extensions and formats, including XLSX (Excel Workbook), XLS (Excel 97-2003 Workbook), CSV, plain text and PDF (export only). The API also enables you to convert DataTable objects into Worksheet and vice versa with ease when you need to work with data from a database.
Spreadsheet documents, sometimes called simply workbooks, house data in single or multiple worksheets. The rich API of SpreadProcessing for .NET MAUI provides various settings for managing the workbook and worksheet theme, protection, named ranges, as well as rows and columns access.
The workbook model API allows you to set multiple spreadsheet row and column attributes. You are able to manually specify a row height and column width or change the column width to automatically fit its contents thanks to the AutoFit functionality. Additionally, each row or column has a hidden state that can be set option which allows users to hide certain rows and columns in the spreadsheet.
Cells are formed where rows and columns intersect in a worksheet. They serve as the primary unit for manipulating and organizing data. With Telerik SpreadProcessing for .NET MAUI you have a complete toolset that enables working with cells. For example, define value and formatting settings, such as fill, border, wrapping, number format, font, text rotation indentation and many more. In addition, predefined cell value types are available to help you easily work with any type of data.
You can display cell values in your desired format by setting number formats. The SpreadProcessing library for .NET MAUI supports predefined number formats, including Currency, Number, Date, Time, Text, as well as custom formats.
Formulas assist users in calculating cell values by providing numerous functions in a spreadsheet. Make use of more than 200 functions built into .NET MAUI SpreadProcessing and even plug custom formulas when you need to.
Thanks to the dedicated SpreadProcessing API, you can insert, position and delete images and shapes in the worksheets.
Hyperlinks help users jump to a specific section of the workbook, open a local file or an external website address. Adding, removing, editing and searching for hyperlinks in the worksheets are easy tasks thanks to the SpreadProcessing library.
Named ranges are collections of cells that can be easily accessed by the name they’ve been given. The feature allows users to refer to the same range of cells multiple times or incorporate a predefined cell range in formulas. You are able to use the named ranges on workbook and worksheet levels.
Users are able to freeze rows and columns in order to simultaneously view content from different parts of the worksheet. Freezing any number of rows and columns is possible thanks to the powerful DocumentProcessing API.
Grouping is an excellent tool for organizing and outlining vast amounts of spreadsheet data. It enables users to group rows or columns in sections that can be later expanded and collapsed. Combining rows or columns into sections, allows users to hide parts of the data, while still keeping it available in the document.
.NET MAUI SpreadProcessing comes with built-in spreadsheet data filtering capabilities. You can filter data by values or value ranges and time periods out of the box. Additionally, you can leverage predefined filters, such as Top, Bottom, Above Average, Fill and ForeColor to apply advanced filtering or use custom logic to create your own filters.
You can create, adjust and apply data sorting logic to select parts of the spreadsheet, such as rows, columns and ranges. This is possible thanks to the Sorting feature which enables you to organize your Data in ascending and descending order, by Fill and ForeColor values, or by custom sorting logic.
The autofill function enables you to automatically fill series of values into worksheet cells, based on a pattern. The SpreadProcessing API for .NET MAUI enables setting cell values to repeat other cell values or applying algorithms for linear, linear trend, exponential, exponential trend sequences and date series.
Data validation function allows you to control what types of values users can input into a cell. You can set specific criteria the data should meet, such as numeric or text values, upper or lower case only, maximum characters or even use a formula to prevent duplicates.
The SpreadProcessing Find and Replace API allows substituting text and numbers in the spreadsheet document. The Find API helps define the search terms and values, where in the document to search them and how to treat certain results, such as formulas behind numeric values, differences in case and multiple occurrences. The Replace API enables replacing the matches with new values.
You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
The SpreadProcessing Page setup enables users to manipulate the size and layout of a worksheet when printing or exporting it. They can change anything from paper size, header and footer settings, margins, orientation, breaks, scaling options for fitting rows and columns on a single page and much more.
Add or copy worksheets, cells and cell ranges within or across workbooks. Fine-tuning the appearance of the pasted content is achievable by specifying formatting options like paste values, formulas, controlling number and visual formatting and more.
Ensure that no sheets are added, deleted, renamed or rearranged by users inside the workbook by enabling the Workbook protection functionality.
Worksheet protection options allow you to enable or disable a set of editing commands for users. Doing that can protect the content and structure of your worksheet from changes, with and without a password.
Ensure your cells are formatted consistently. Styles allow you to simultaneously apply a set of predefined or custom format options to cells across your entire workbook, set cell fonts, colors and font sizes, borders, alignment and more.
The .NET MAUI SpreadProcessing library is compliant with the Federal Information Processing Standards (FIPS), thus enabling you to create documents that fully conform to the FIPS 140-2 standard.
Make your workbook formatting consistent with ease. Use out-of-the-box Document themes to set colors, fonts and a variety of graphic effects and apply the style to the entire document. You can also create your own custom style.