UI for WinForms
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.
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.
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.
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.
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.
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.
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.
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.
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.
You can insert, position and delete images in worksheets through a dedicated API.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
You have the ability to merge two or more adjacent cells into a single cell that spans over multiple rows and columns.
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.
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.
You can disable modifications to the workbook structure. In this way, users cannot add, remove, rename or reorder sheets.
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.
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.
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.
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.