background

UI for WinForms

WinForms SpreadProcessing

  • The Telerik UI for WinForms SpreadProcessing Library allows you to generate and convert documents to XLSX, CSV, TXT and PDF. Ships with built-in support for computation of more than 200 functions, like SUM, AVERAGE, and more.  
  • Part of the Telerik UI for WinForms library along with 160+ professionally-designed UI controls.
  • Includes support, documentation, demos, virtual classrooms, Visual Studio Extensions and more!
Telerik UI for WinForms Ninja
  • Full-featured SpreadProcessing Library

    SpreadProcessing for WinForms 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 model 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

     
    WinForms SpreadProcessing Library Overview
  • No External Dependencies

    The WinForms SpreadProcessing operates independently from external libraries or UI. Process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other spreadsheet software installed on the client or server.

    No Dependancies in WinForms SpreadProcessing Library
  • Supported Formats

    The Telerik UI for WinForms SpreadProcessing Library supports popular file extensions and spreadsheet formats, including 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

    Supported Formats in WinForms SpreadProcessing Library
  • Workbooks and Worksheets

    Spreadsheet documents, or simply workbooks, contain one or several worksheets, where you can organize data in cells. The powerful API of the WinForms SpreadProcessing library enables you to modify both the workbook and worksheet settings, including theme, named ranges, protection, as well as rows and columns access.

    Documentation on Workbooks and Worksheets in RadSpreadProcessing

  • Rows and Columns

    The workbook model allows you to control different row and column parameters. The API provides options to manually define their width and height or use the AutoFit functionality to automatically calculate the size of the rows and columns based on their contents. You can additionally set the visibility properties, allowing users to hide rows and columns in the spreadsheet.

    Documentation on Rows and Columns in RadSpreadProcessing

    WinForms SpreadProcessing Library - Rows and Columns
  • Cells

    Cells are the core data unit of worksheets. Take advantage of a complete set of options for working with cells, including setting their values and formatting properties. You can allow users to change the cell fill, border, font, wrapping, number format, text rotation indentation and many more attributes. Cell value types are available for you out of the box to conveniently handle any type of data.

    Documentation on how to work with Cells in RadSpreadProcessing

  • Cell References

    The support for cell references for whole columns and rows includes support for Absolute, Relative and Mixed cell references, e.g., $1:$2 and A:D. All these come in handy when you need to work with a range of cells and pass them into a formula, for example. 

    SpreadProcessing - Cell References
  • Number Formats

    The SpreadProcessing library has readily available number formats you can apply to cell values. Choose from our predefined formats, including Number, Currency, Date, Time and Text, or create your own custom format.

    Documentation on how to work with Number Formats in RadSpreadProcessing

    Number Formats in WinForms SpreadProcessing Library
  • Formulas

    Formulas help calculate the value of a cell in the spreadsheet. Enjoy more than 200 built-in functions and the ability to easily plug custom formulas whenever you need to.

    Documentation on how to work with Formulas in RadSpreadProcessing

    Formulas Support in WinForms SpreadProcessing Library
  • Shapes and Images

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

    Documentation on Shapes and Images support in RadSpreadProcessing

    Shapes and Images in WinForms SpreadProcessing Library
  • Charts

    Help users make better sense of data with charts. SpreadProcessing for WinForms enables you to add a wide range of chart types users can choose from, including Line, Bar, Column, Scatter, Bubble, Pie, Doughnut, Area as well as combined charts or different series. The SpreadProcessing Charts are supported in .NET Standard as well.

    Documentation on Charts support in RadSpreadProcessing

    Charts Support in WinForms SpreadProcessing Library
  • Insert and Delete Comments

    The insert and delete comments functionality allows adding information about a cell, replying to a comment, or deleting comments. Information about the creation date, author and whether the comment is resolved is also readily available. 

    SpreadProcessing - Insert and Delete Comments
  • Hyperlinks are references that point users to locations inside the workbook, help them open a local file or access an external website. You can add, remove, edit and search for hyperlinks in the worksheets of the document.

    Documentation on Hyperlinks support in RadSpreadProcessing

    Hyperlinks in Winforms SpreadProcessing Library
  • Named Ranges

    A named range is a range of a single cell or multiple cells to which you assign a name. They allow users to refer multiple times to the same range of cells or incorporate a predefined range of cells in formulas. You can use the named ranges on workbook and worksheet levels. You can use the named ranges on workbook and worksheet levels.

    Documentation on Names and Named Ranges in RadSpreadProcessing

  • Freeze Panes

    Freeze panes allows users to freeze any number of rows and columns so they can see them no matter where they go in the worksheet.

    Documentation on Freezing Panes in RadSpreadProcessing

    Freeze Panes Support in WinForms SpreadProcessing Library
  • Grouping

    The SpreadProcessing grouping feature helps organize worksheet data into sections. You can group rows or columns to highlight relevant information, compare different data or collapse what distracts you.

    Documentation on Grouping support in RadSpreadProcessing

    Grouping Support in WinForms SpreadProcessing Library
  • Filtering

    The filtering functionality of SpreadProcessing for WinForms allows you to set various predefined and custom filters in worksheets. Out of the box, you can filter spreadsheet data by values or ranges of values, by certain time period—last month, last quarter, last year, or sort data with Top, Bottom, and Above and Below Average advanced filters. You can additionally filter by color with the Fill and ForeColor filters.

    Documentation on Filtering support in RadSpreadProcessing
    Filtering Support in WinForms SpreadProcessing Library
  • Sorting

    The sorting function enables you to create and modify sorting rules and apply them to parts of the spreadsheet. Users can sort data in ascending and descending order, by color as well as by using custom sorting logic.

    Documentation on Sorting support in RadSpreadProcessing

    Sorting Support in WinForms SpreadProcessing Library
  • Autofill and Series

    The SpreadProcessing API supports populating worksheet cells automatically with data that follows predefined logic. You can set cells to repeat values or use algorithms for linear, linear trend, exponential, exponential trend sequences and date series.

    Documentation on AutoFill and Series support in RadSpreadProcessing

    Autofill and Series WinForms SpreadProcessing Library
  • Data Validation

    Data validation helps you ensure data quality and data accuracy by controlling the type of data or value users are allowed to enter into a cell. You can specify rules for text length, numbers and dates, predefine values for dropdown lists or customize a condition with formulas.

    Documentation on Data Validation support in RadSpreadProcessing

    Data Validation WinForms SpreadProcessing Library
  • 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.

    Documentation on how to use Find and Replace in RadSpreadProcessing

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

    Documentation on how to merge and unmerge cells with RadSpreadProcessing

    Merge and Unmerge Cells in WinForms SpreadProcessing
  • Page Setup

    Page setup defines 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, margins, breaks, scaling to fit rows and columns on a single page and many more.

    Documentation on how to setup a page for printing with RadSpreadProcessing

     Print Page Setup in WinForms SpreadProcessing Library
  • 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 disable modifications to the workbook structure. In this way, users cannot add, remove, rename or reorder sheets.

    Documentation on Workbook Protection in RadSpreadProcessing

    Workbook Protection in WinForms SpreadProcessing Library
  • Worksheet Protection

    Lock the content and structure of your worksheet to limit the types of modifications users can make. You can specify the commands available to users when protection is enabled.

    You can protect the content and structure of your worksheet. Through the available options, you can selectively allow or restrict users to make changes like edit cells, insert and delete columns and insert and delete rows. 

    Documentation on Worksheet Protection in RadSpreadProcessing

    Worksheet Protection in WinForms SpreadProcessing Library
  • Styling

    Ensure cell formatting consistency throughout your workbook. Styling applies a set of formatting characteristics, such as font, font size, border, alignment and more to cells in one go. You can choose to apply a built-in style or create your own.

    Documentation on Cell Styling and Document Themes in RadSpreadProcessing

    Styling Support in WinForms SpreadProcessing Library
  • FIPS Compliance

    The WinForms SpreadProcessing library is fully compliant with the Federal Information Processing Standards (FIPS), ensuring you can create documents that conform to the FIPS 140-2 standard.

    Documentation on RadSpreadProcessing FIPS Compliance

  • Theming

    The document model offers several predefined themes called Document themes. Each theme enables you to specify the colors, fonts and a variety of graphic effects you can apply to the appearance of the whole workbook.

    Documentation on the supported Document Themes in RadSpreadProcessing

    Theming Support in WinForms SpreadProcessing Library

All Winforms Components

Next Steps