Edit this page
Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight

Overview

This library enables you to work with spreadsheet documents – create 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.

Rad Spread Processing Overview 01

RadSpreadProcessing comes with support for:

  • Shapes and Images: API for insertion, positioning and deletion of images in worksheets.

  • Hyperlinks: The API enables you to add, remove, edit and search for hyperlinks in the worksheets of the document.

  • Workbook Protection: Prevents the users from modifying the workbook by adding, removing, renaming or reordering sheets.

  • Worksheet protection: Restricts the user from modifying the content and structure of the worksheet. Additionally, the model offers protection options that let you choose a set of commands that will be available to the user when protection is enabled.

  • Grouping: Helps you organize data in sections, to be able to show and hide the currently relevant chunks.

  • Formulas: The library comes with more than 200 built-in functions. The API enables you to easily plug custom ones as well.

  • Named ranges: You can use the named ranges on workbook and worksheet levels.

  • Styling: You can apply styles to the cells. The API allows you to duplicate one of the predefined styles or create a new one according to your preferences.

  • Theming: The document model comes with predefined themes called Document themes. They enable you to specify colors, fonts and a variety of graphic effects in a document and affect the look and feel of the whole workbook.

  • Resizing: Auto fit or resize rows and columns.

  • Number Formats: Enable you to format the data in the cells so it can be easily readable.

  • Copy/Paste: Add or copy worksheets within or across workbooks. Of course, copying and pasting of cells is supported as well.

  • Data Validation: Enables you to control the type of data or the values that users enter into a cell. Different data validation rules are available, including list, number, date, text length or custom rules.

  • Filtering worksheet data.

  • Sorting the data in the worksheet.

  • Find and replace data.

  • Freeze Panes: Keep part of the worksheet visible at all times when scrolling.

  • Hidden rows and columns: The API of the workbook model allows you to set the hidden state of each row or column.

  • 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.

  • Auto fill and Series: Fill cells automatically with data following a specific pattern.

  • Page Setup: Set and get header and footer settings and apply various page setup options like paper size, orientation, scaling, margins, breaks, etc. Apply print settings.

  • History: The document model provides the possibility to maintain a history stack that tracks all changes to the content of the workbook. Each worksheet has its own history stack.

Supported formats:

See Also