WinForms SpreadProcessing Overview

RadSpreadProcessing is part of the Telerik Document Processing libraries. The full documentation for this component is available at https://docs.telerik.com/devtools/document-processing/libraries/radspreadsprocessing.

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.

Telerik UI for WinForms Ninja image

The SpreadProcessing is part of Telerik UI for WinForms, a professional grade UI library with 160+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

WinForms RadSpreadProcessing Overview

RadSpreadProcessing comes with support for:

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

  • Charts: Add, remove and manipulate chart objects in your spreadsheet documents.

  • Conditional Formatting: Make it easy to analyze data, find critical issues, patterns and trends by representing the data inside in a user-friendly manner.

  • 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. The document model exposes the following categories of predefined formats: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and also allows you to create custom formats.

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

  • Comments: You can leave comments and replies on cells, which allows for easier team communication.

  • Notes: Note important information in your worksheet.

Supported formats:

Telerik UI for WinForms Learning Resources

Telerik UI for WinForms Additional Resources

See Also

In this article