UI for WPF
WPF SpreadProcessingSpreadProcessing for WPF 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.
SpreadProcessing for WPF is completely independent from external libraries or UI. Process Microsoft Excel documents without having Microsoft Excel, Microsoft Office or any other software installed on the client or server.
The Telerik WPF SpreadProcessing library supports the most frequently used spreadsheet formats—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
Workbooks are an alternative name for spreadsheet documents. They contain one or more worksheets, where the actual cells in the spreadsheet live. The WPF SpreadProcessing library features a rich API for manipulating both workbooks and worksheets with options such as setting the theme, named ranges, protection, as well as accessing the rows and columns.
Documentation on Workbooks and Worksheets in RadSpreadProcessing
The API of the workbook model allows you to manipulate row height and column width by setting them manually or by utilizing the AutoFit feature to automatically calculate the row and column size based on their contents. You can additionally set their visibility properties allowing to hide rows and columns in the spreadsheet.
Cells are the basic unit of data in worksheets—they are the intersecting point of rows and columns. The WPF SpreadProcessing API features multiple options for formatting cells and defining their value, such as fill, border, font, wrapping, number format, text rotation indentation and many more. In addition, convenient predefined cell value types are available, making it easier to work with any type of data.
Documentation on how to work with Cells in RadSpreadProcessing
The supported cell references for rows and columns now include Absolute, Relative and Mixed types, 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 for WPF provides the ability to add charts to spreadsheet documents. Help users better understand data with the right chart type. Supported charts include 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 as a comment, as well as deleting or replying to a comment. Information about the creation date, author and whether the comment is resolved is also readily available.
Named ranges are collections of cells, which can be easily accessed by their name. Useful when need to refer multiple times to the same range of cells or you want to provide easy access to a predefined range of cells to the users to incorporate in formulas. You can use the named ranges on workbook and worksheet levels.
Documentation on Names and Named Ranges in RadSpreadProcessing
The SpreadProcessing grouping feature allows to place rows and/or columns in sections, which could be expanded and collapsed by the users. Quite useful, when we want to hide the complexity of the detailed data and present just the summary of it, while still keeping it available for users.
The filtering functionality of the WPF SpreadProcessing library allows setting predefined filters in the resulted document worksheets. The available filter options include filtering by certain values or range of values, for certain period of time and using predefined filters such as Top or Bottom, Above Average and Fill and ForeColor. The library also supports custom logic for advanced filtering of spreadsheet data.
The sorting feature allows to create and modify sorting rules in worksheets, resulting in sort rules applied to the needed parts of the spreadsheet. Sorting can be specified using ascending and descending order of the cell values, Fill and ForeColor values as well as with custom sorting logic.
With the auto filling functionality, the SpreadProcessing API enables filling cells automatically with data following a specific pattern. The supported patterns include repeating cell values or applying the following algorithms: linear, linear trend, exponential, exponential trend and date series.
Documentation on AutoFill and Series support in RadSpreadProcessing
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
Worksheet protection helps you maintain control over the worksheet data and structure and ensures that users cannot change it. The worksheet protection options allow you to select what types of actions will be available to users, to which cell ranges the protection will apply to. You can protect worksheets with or without a password.
Documentation on Worksheet Protection in RadSpreadProcessing
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4