background

UI for ASP.NET AJAX

ASP.NET AJAX SpreadProcessing

  • Use the ASP.NET AJAX SpreadProcessing library to create spreadsheet documents from scratch, modify existing ones or convert between the most common formats.
  • Part of the Telerik UI for ASP.NET AJAX library along with 120+ professionally designed UI components.
  • Includes support, documentation, demos, virtual classrooms and more!
Telerik UI for ASP.NET AJAX SpreadProcessing - Header
  • ASP.NET AJAX SpreadProcessing Library Overview

    SpreadProcessing for ASP.NET AJAX is a document processing library that enables you to create spreadsheet documents, modify existing ones or convert between the most common spreadsheet formats. You can save the generated workbook to a local file, or stream it to the client browser.

    The library 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. 

    Documentation of the Telerik SpreadProcessing Library

    Telerik UI for ASP.NET AJAX SpreadProcessing - Overview
  • No External Dependencies

    The Telerik ASP.NET AJAX SpreadProcessing library is completely independent from external libraries or UI. You don’t need Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server to process Microsoft Excel documents.

    Telerik UI for ASP.NET AJAX SpreadProcessing - No dependancies
  • Supported Formats

    The Telerik SpreadProcessing library supports the most common 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.

    Documentation on the supported import and export formats of RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - Supported Formats
  • Workbooks and Worksheets

    Workbooks, or spreadsheet documents, contain one or multiple worksheets. Worksheets represent a collection of cells organized in rows and columns. The ASP.NET AJAX SpreadProcessing library features a rich API for configuring both the workbook and worksheet settings, such as theme, named ranges, protection, as well as rows and columns access.

    Documentation on Workbooks and Worksheets in RadSpreadProcessing

  • Rows and Columns

    The API of the workbook model allows you to control different row and column parameters. You can manually set their width and height. Alternatively, you can utilize the AutoFit functionality, which will automatically calculate the size of the rows and columns based on their contents. You also have the option to set the visibility properties, allowing users to hide rows and columns in the spreadsheet.

    Documentation on Rows and Columns in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - rows and columns
  • Cells

    Cells are the core data unit of worksheets. The SpreadProcessing API features multiple options for working with cells, such as defining their value and changing their properties. You can format the cell fill, border, font, wrapping, number format, text rotation indentation and many more attributes. Predefined cell value types are available for you to conveniently handle any type of data.

    Documentation on how to work with Cells in RadSpreadProcessing

  • Number Formats

    The ASP.NET AJAX SpreadProcessing library supports predefined number formats which can be applied to cell values in the spreadsheet. The available formats include Number, Currency, Date, Time, Text, as well as custom formats.

    Documentation on how to work with Number Formats in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - number formats
  • Formulas

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

    Documentation on how to work with Formulas in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - formulas
  • Shapes and Images

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

    Documentation on Shapes and Images support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - shapes and images
  • Charts

    Add charts to spreadsheet documents to help users better understand data. ASP.NET AJAX SpreadProcessing supports various chart types, including Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area as well as combined charts or different series.

    Documentation on Charts support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - Charts
  • Hyperlinks help users jump to sections of the workbook, open a local file or access a website address. You can add, remove, edit and search for hyperlinks in the worksheets of the document.

    Documentation on Hyperlinks support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - Hyperlinks
  • Named Ranges

    Named ranges are collections of cells that can be easily accessed by the name they’ve been given. Handy when you need to reuse a reference to the same range of cells or you want to provide users with easy access to a predefined range of cells they can incorporate in formulas. You can use the named ranges on workbook and worksheet levels.

    Documentation on Names and Named Ranges in RadSpreadProcessing

  • Freeze Panes

    Freeze panes is a useful feature allowing part of the worksheet to always stay visible as users are scrolling. The API allows freezing any number of rows and columns.

    Documentation on Freezing Panes in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - freeze panes
  • Grouping

    Users can group rows or columns in sections that ca be expanded and collapsed—a handy way to hide the details and present just the summary of the worksheet data, while still keeping the underlying information available to see.

    Documentation on Grouping support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - grouping
  • Filtering

    Filtering in ASP.NET AJAX SpreadProcessing allows you to set standard filters in worksheets and use custom logic for advanced operations. Out of the box, you can leverage our built-in functionality to filter data by certain values or range of values, find top or bottom, above or below average values and narrow down data for a certain period of time, such as last month and last quarter. You can also use Fill and ForeColor filters to filter for specific cell and font colors.

    Documentation on Filtering support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - filtering
  • Sorting

    You can create and modify sorting rules and apply them to 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.

    Documentation on Sorting support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - sorting
  • Autofill and Series

    The autofill feature enables you to automatically populate worksheet cells with data following a specific pattern. You can set cell values to duplicate another cell’s value or apply algorithms for linear, linear trend, exponential, exponential trend sequences and date series.

    Documentation on AutoFill and Series support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - autofill and series
  • Data Validation

    Data validation enables you to specify the type of data or value users can enter in a cell. You can limit characters, set a time range, define a list of values, allow only whole numbers, allow only time or use formulas to customize rules.

    Documentation on Data Validation support in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - data validation
  • Find and Replace

    The Find and Replace APIs enable you to find and replace text and numbers in the spreadsheet document. You can define what to search, where in the document to search it and how to treat edge cases, such as whether to use a formula or the result value, match case, return single or multiple occurrences. The Replace API allows replacing the matches from the search with a desired value.

    Documentation on how to use Find and Replace in RadSpreadProcessing

  • Merge and Unmerge Cells

    You can merge two or more adjacent cells into a single cell that spans over multiple rows and columns.

    Documentation on how to merge and unmerge cells with RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - merge and unmerge cells
  • Page Setup

    Page Setup lets you set the layout and print options of a page. You can control header and footer settings, paper size, orientation, margins, breaks and scaling options to fit rows and columns on a single page, plus many more.

    Documentation on how to setup a page for printing with RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing -  print page setup
  • Copy/Paste

    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.

    Documentation on the Clipboard support in RadSpreadProcessing

  • Workbook Protection

    You can protect the structure of your workbook so that users cannot add, remove, rename or reorder sheets.

    Documentation on Workbook Protection in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - workbook protection
  • Worksheet Protection

    You can protect every single worksheet in your workbook and prevent content from being edited. The model offers protection options that let you choose a set of commands that will be available to the user when protection is enabled.

    Documentation on Worksheet Protection in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - worksheet protection
  • Styling

    You can use styling to uniformly and simultaneously format cell fonts and font sizes, cell borders, alignment and more properties. You can choose to duplicate a predefined style or create a custom one.

    Documentation on Cell Styling and Document Themes in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - styling
  • FIPS Compliance

    The ASP.NET AJAX SpreadProcessing library is fully compliant with the Federal Information Processing Standards (FIPS), enabling you to create documents that conform to the FIPS 140-2 standard.

    Documentation on RadSpreadProcessing FIPS Compliance

  • Theming

    You can customize the appearance of a workbook with themes. ASP.NET AJAX SpreadProcessing includes predefined themes, called Document themes, which allow you to set the colors, fonts and a variety of graphic effects of the workbook.

    Documentation on the supported Document Themes in RadSpreadProcessing

    Telerik UI for ASP.NET AJAX SpreadProcessing - theming
Next Steps