Progress Telerik UI for WPF
SpreadProcessing
-
Overview
RadSpreadProcessing for WPF 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.
-
RadSpreadProcessing for WPF 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
Prevents changes to your workbook structure. Users cannot add, remove, rename or reorder sheets.
Worksheet Protection
Helps you maintain control over the worksheet data and structure and ensures that it doesn't change. The protection options allow you to select what types of actions will be available to users.
Grouping
Helps you organize data in sections to be able to show and hide the currently relevant chunks.
Formulas
Formulas are expressions calculating the value of a cell in the spreadsheet. The RadSpreadProcessing 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
Apply the same formatting style to cells across your workbook. Choose from the Telerik RadSpreadProcessing built-in styles or create a new one to format cell fonts and font sizes, borders, alignment and more.
Theming
Unify the look of your workbook with out-of-the-box Document themes. Set the colors, fonts and a variety of graphic effects and apply consistent formatting to the entire document.
Resizing
Autofit or resize rows and columns.
Number Formats
Enable you to format the numerical data in cells so it can be easily read.
Copy/Paste
Add or copy worksheets within or across workbooks. Of course, copy and paste of cells is supported as well.
Data Validation
Gives you control over the type of data or values users can enter into a cell. You can define different data validation rules about lists, numbers, dates, text length or custom values.
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
The library supports the most frequently used spreadsheet formats—plain text, XLSX, CSV and PDF (export only).
Next Steps
See UI for WPF in action.
With dedicated technical support.