background

Document Processing

Spread Processing

  • Generate and convert documents to XLSX, CSV, TXT and PDF with the Telerik SpreadProcessing Library. Ships with built-in support for computation of more than 200 functions, like SUM, AVERAGE, and more.
spreadprocessing-header
  • Overview

    Telerik SpreadProcessing Library is a document processing library that enables you to work with spreadsheet documents using C# and VB.NET. Create new ones from scratch, modify existing documents or convert between the most common spreadsheet formats. You can save the generated workbook to a local file, stream, or stream it to the client browser. 

    The library closely follows the established document standard defined in the Office Open XML specification and supports .NET Framework, .NET Core and .NET Standard.  

    Documentation of the Telerik SpreadProcessing Library 

    Telerik SpreadProcessing Library - Overview
  • No External Dependencies

    Telerik SpreadProcessing is completely independent from external libraries or UI. Process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other software installed on the client or server. 
    Telrik SpreadProcessing - No external dependencies
  • Supported Formats

    The Telerik SpreadProcessing library supports the most frequently used spreadsheet formats—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.   

     

    Telerik SpreadProcessing - Supported Formats
  • Support for XLSM

    The Telerik SpreadProcessing Library now support working with XLSM files. In addition to XLSX, XLS, CSV, TXT and PDF, we’ve added support for XLSM files without working with macros. Macros won’t be stripped from your file; however, they won’t be active in applications.  

    For more information visit the Telerik SpreadProcessing Library documentation
  • Workbooks and Worksheets

    Workbooks are an alternative name for spreadsheet documents. They contain one or more worksheets, where the actual cells in the spreadsheet live. The Telerik SpreadProcessing library features a rich API for manipulating both workbooks and worksheets with options such as setting the theme, named ranges, protection, as well as accessing the rows and columns. 

    Documentation on Workbooks and Worksheets in RadSpreadProcessing  

  • Rows and Columns

    The API of the workbook model allows you to manipulate row height and column width by setting them manually or by utilizing the AutoFit feature to automatically calculate the row and column size based on their contents. You can additionally set their visibility properties allowing to hide rows and columns in the spreadsheet. 

    Telerik SpreadProcessing Library  - Rows and Columns Support
  • Cells

    Cells are the basic unit of data in worksheets—they are the intersecting point of rows and columns. The Telerik SpreadProcessing API features multiple options for formatting cells and defining their value, such as fill, border, font, wrapping, number format, text rotation indentation and many more. In addition, convenient predefined cell value types are available, making it easier to work with any type of data.  

  • Number Formats

    The SpreadProcessing library supports a vast array of predefined number formats that can be applied to cell values in the spreadsheet. The formats include Number, Currency, Date, Time, Text, as well as custom formats.  

    Telerik SpreadProcessing - number formats supports
  • Formulas

    Formulas are expressions calculating the value of a cell in the spreadsheet. The Telerik SpreadProcessing library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well. 

    Telerik SpreadProcessing - formulas support
  • Shapes and Images

    You can insert, position and delete images in worksheets through a dedicated API. 

    Telerik SpreadProcessing - shapes and images support
  • Charts

    Telerik SpreadProcessing provides the ability to add charts to spreadsheet documents. Help users better understand data with the right chart type. Supported charts include Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area, as well as combined charts or different series.  

    Telerik SpreadProcessing Library - Charts Support
  • Hyperlinks help users quickly navigate to a specific part of the workbook, open a local file or website address. You can add, remove, edit and search for hyperlinks in the worksheets of the document. 

    Telerik SpreadProcessing Library - Hyperlinks support
  • Named Ranges

    Named ranges are collections of cells, which can be easily accessed by their name. Useful when need to refer multiple times to the same range of cells or you want to provide easy access to a predefined range of cells to the users to incorporate in formulas. You can use the named ranges on workbook and worksheet levels. 

  • Freeze Panes

    Freeze panes is a useful feature allowing part of the worksheet to remain visible at all times when users are scrolling. The API allows freezing any number of rows and columns.  

    Telerik SpreadProcessing Library - Freeze Panes Support
  • Grouping

    The SpreadProcessing grouping feature allows to place rows and/or columns in sections, which could be expanded and collapsed by the users. Quite useful, when we want to hide the complexity of the detailed data and present just the summary of it, while still keeping it available for users.  

    Telerik SpreadProcessing Library - Grouping Support
  • Filtering

    The filtering functionality of the Telerik SpreadProcessing library allows setting predefined filters in the resulted document worksheets. The available filter options include filtering by certain values or range of values, for certain period of time and using predefined filters such as Top or Bottom, Above Average and Fill and ForeColor. The library also supports custom logic for advanced filtering of spreadsheet data.  

     

    Telerik SpreadProcessing Library - Filtering Support
  • Sorting

    The sorting feature allows to create and modify sorting rules in worksheets, resulting in sort rules applied to the needed parts of the spreadsheet. Sorting can be specified using ascending and descending order of the cell values, Fill and ForeColor values as well as with custom sorting logic.  

    Telerik SpreadProcessing Library - Sorting Support
  • Autofill and Series

    With the auto filling functionality, the SpreadProcessing API enables filling cells automatically with data following a specific pattern. The supported patterns include repeating cell values or applying the following algorithms: linear, linear trend, exponential, exponential trend and date series.  

    Documentation on AutoFill and Series support in RadSpreadProcessing 

    Telerik SpreadProcessing - Autofill and Series Support
  • Data Validation

    Gives you control over the type of data or values users can enter into a cell. You can define different data validation rules about required value, lists, numbers, dates, text length or custom values. 

    Telerik SpreadProcessing Library - Data Validation Support
  • Find and Replace

    The Find and Replace APIs provides the ability to find an replace text and numbers in the spreadsheet document. The highly customizable Find functionality allows you to define what to search, where in the document to search it and how to treat subtleties like case-sensitive data, single and multiple occurrences and whether to return the formula or the result value. The Replace API allows replacing the find results with a desired value.  

  • Merge and Unmerge Cells

    You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns. 

    Telerik SpreadProcessing Library - Merge and Unmerge cells Support
  • Page Setup

    Page Setup allows controlling how the worksheet will look when printed or exported to PDF. Set and get header and footer settings and apply various page setup options like paper size, orientation, scaling, margins, breaks, options how to fit rows and columns on a single page and many more.  

    Telerik SpreadProcessing Library -  Print Page Setup Support
  • Copy/Paste

    You can add or copy worksheets, cells and cell ranges within or across workbooks. Fine-tune the formatting of the pasted content by specifying options like paste values, formulas, control number and visual formatting and more. 

  • Workbook Protection

    Workbook protection prevents changes to your workbook structure. You can restrict editing so users cannot add, remove, rename or reorder sheets. 

    Telerik SpreadProcessing Library  - Workbook Protection Support
  • Worksheet Protection

    Worksheet protection helps you maintain control over the worksheet data and structure and ensures that users cannot change it. The worksheet protection options allow you to select what types of actions will be available to users, to which cell ranges the protection will apply to. You can protect worksheets with or without a password. 

    Telerik SpreadProcessing Library - Worksheet Protection Support
  • Styling

    Apply the same formatting style to cells across your workbook. Choose from the Telerik SpreadProcessing built-in styles or create a new one to format cell colors, fonts and font sizes, borders, alignment, format and more. 

    Telerik SpreadProcessing - Styling Support
  • FIPS Compliance

    The Telerik SpreadProcessing library complies with the Federal Information Processing Standards (FIPS) and you can create documents that conform to the FIPS 140-2 standard.  

    Documentation on RadSpreadProcessing FIPS Compliance 
  • Theming

    Unify the look of your workbook with out-of-the-box spreadsheet Document themes. Set the colors, fonts and a variety of graphic effects and apply consistent formatting to the entire document by utilizing the predefined themes or creating one of your own. 

    Telerik SpreadProcessing Library - Theming Support
next-steps-background