Progress Telerik UI for ASP.NET Core
SpreadProcessing for ASP.NET Core is a document processing library that enables you to create, modify or convert documents between the most common spreadsheet formats. The library model closely follows the established document standard, defined in the Office Open XML specification, enables you to use C# and VB.NET and supports .NET Framework, .NET Core and .NET Standard. You can save the generated workbook to a stream, a local file, or stream it to the client browser.
The Telerik ASP.NET Core SpreadProcessing library is completely free from dependencies on external libraries or UI. Handle Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server.
Telerik SpreadProcessing offers full support for the most popular 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 easily convert DataTable objects into Worksheet and vice versa in case you need to work with data from a database.
Workbooks, or alternatively spreadsheet documents, contain one or multiple worksheets, where cells are organized in rows and columns. SpreadProcessing for ASP.NET Core offers a powerful API for setting various workbooks and worksheet properties, such as theme, named ranges, protection, as well as rows and columns access.
You can manipulate worksheet rows in columns in several ways. The workbook model API allows you to manually define column width and row height or use AutoFit functionality to automatically resize the rows and columns to fit their contents. You can also set the visibility properties to allow users to hide certain rows and columns in the spreadsheet.
Cells are the building blocks of worksheets, where data operations take place. The ASP.NET Core SpreadProcessing API gives you a complete set of options for working with cells. You can set cell values and specify their attributes, including cell fill, border, font, wrapping, number format, text rotation indentation and many more. Predefined cell value types are available for you to conveniently handle any type of data format.
You can format cells in a spreadsheet to display values in your desired format. The SpreadProcessing library supports predefined number formats, including Number, Currency, Date, Time, Text, as well as custom formats.
Formulas allow users to perform calculations based on specific cell values. The SpreadProcessing library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.
Through a dedicated API, you can insert, position and delete images in worksheets.
Hyperlinks are shortcuts that give users quick access to a specific element within the document, a local file or an external website address. You can add, remove, edit and search for hyperlinks in the worksheets of the document.
A named range is a range of one or multiple cells that is given a name. Users can utilize the name in place of normal cell references in formulas and reuse the same range of cells multiple times in a document. You can use the named ranges on workbook and worksheet levels.
The feature enables users to always keep certain rows or columns in view as they move horizontally or vertically through the worksheet. The API allows freezing any number of rows and columns.
Grouping rows and columns allows users to collapse entire parts of the worksheet that contain data they want to temporarily hide. In this way, they can summarize, compare, combine and categorize data without deleting the underlying information.
Filtering in ASP.NET Core SpreadProcessing allows you to set standard filters in worksheets and use custom logic to define your own. Leverage our built-in functionality for filtering data by certain values or value ranges, by date and time period and advanced filters for Top, Bottom and Above Average values. You can also use Fill and ForeColor filters to filter for specific cell and font colors.
Sorting enables you to define criteria for ordering and organizing worksheet data. Sorting can be applied based on the ascending and descending order of the cell values like numbers and text, and Fill and ForeColor values. You can also enable custom sorting to replace the default sorting logic with your own logic.
Use the SpreadProcessing autofill feature to automatically populate worksheet cells with data based on a specific pattern. Supported autofill options include repeating a cell value or applying growth sequences (linear, linear trend, exponential, exponential trend) and date series.
Use data validation to ensure data quality and prevent errors by defining clear rules. You can specify the type of data or values that are allowed into a cell—restrict to numbers, date or time, limit text length, predefine dropdown values or use a custom input rule.
The Find and Replace function enables you to look up text and numbers in the spreadsheet document and substitute them with a new value. The Find API helps you define what to search, where in the document to search and how to treat formulas, cases, single and multiple occurrences. The Replace API allows substituting the matches from the search with a desired value.
You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
Page setup allows users to customize the size and layout of a worksheet before printing or export it. They can control header and footer settings, paper size, orientation, margins, breaks, scaling options for fitting rows and columns on a single page and many more.
Add or copy worksheets, cells and cell ranges within or across workbooks. You can fine-tune the appearance of the pasted content by specifying formatting options like paste values, formulas, control number and visual formatting and more.
You can protect your workbook from user modifications like adding, removing, renaming or reordering sheets.
You can use targeted protection to restrict users from modifying the content and elements of the worksheet. The flexible protection options allow you to select what types of commands will be available to users.
Using styles to mass-format cells ensures their appearance is consistent throughout the document. Styles enable you to simultaneously apply a set of formatting options like color, size, border, alignment and more to cells in your workbook.
The ASP.NET Core SpreadProcessing library is compliant with the Federal Information Processing Standards (FIPS) and you can create documents that fully conform to the FIPS 140-2 standard.
Use the predefined SpreadProcessing Document themes to achieve a consistent style across your entire workbook. Customize the colors, fonts and a variety of graphic effects of the document.