default

Progress Telerik UI for WinForms

SpreadProcessing

  • Overview

    RadSpreadProcessing for WinForms is a document processing library that enables you to work with spreadsheet documents—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.

    Telerik.Sitefinity.Libraries.Model.Image..AlternativeText
  • RadSpreadProcessing for WinForms supports:

    Shapes and Images

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

    Hyperlinks

    You can add, remove, edit and search for hyperlinks in the worksheets of the document.

    Workbook Protection

    Ensures that no sheets are added, deleted, renamed or rearranged by users inside the workbook.

    Worksheet Protection

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

    Grouping

    Make you data more manageable. Collapse or expand grouped parts of your worksheet to focus on the information you need.

    Formulas

    Enjoy more than 200 built-in functions and the ability to easily plug custom formulas whenever you need to.

    Named Ranges

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

    Styling

    Ensure your cells are formatted consistently. Styles allow you to simultaneously apply a set of predefined or custom format options to cells across your entire workbook.

    Theming

    Easily make your workbook formatting consistent. Use out-of-the-box Document themes to set the colors, fonts and a variety of graphic effects and apply the style to the entire document.

    Resizing

    Autofit or resize rows and columns.

    Number Formats

    Display numbers in the correct format —currency, percentages, decimals, dates, phone numbers and more.

    Copy/Paste

    Add or copy worksheets within or across workbooks. Of course, copy and paste of cells is supported as well.

    Data Validation

    Controls what types of values users can input into a cell. You can set certain criteria the data should meet, such as upper or lower case only, numeric or text values, maximum characters or even use a formula to prevent duplicates.

    Filtering

    Filtering worksheet data.

    Sorting

    Sorting the data in the worksheet.

    Find and Replace

    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.

    Autofill 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

    • XLSX
    • CSV
    • Plain text
    • PDF (export only)
    Telerik.Sitefinity.Libraries.Model.Image..AlternativeText

Next Steps

Online help Access our online documentation.
Compare pricing Check out the offers. Purchase an individual suite or treat yourself to one of our bundles.
Download 30-day free trial Try UI for WinForms with dedicated technical support.