In This Topic
Spread for WPF comes with a variety of features to make your applications faster and easier to use. WPF spreadsheet control includes support for import/export, full cell customization, an extensive calculation engine with a wide range of functions, and much more.
Some of the popular features are listed below.
- Import/Export Excel Files
Support seamless import and export of spreadsheets to Excel and other file formats. This feature supports integrated printing with control over page orientation, margins, size, and header/footer text.
- Tables and Table Styles
Create tables with built-in or custom styles to enhance the visual appeal and clarity of your data. You can also apply custom formatting options to highlight key information and improve readability.
- Charts
Visualize data effectively with different chart types, such as Column, Line, Bar, Area, Stock, Surface, Histogram, Box, and many more.
- Merge Cells
Give your worksheet a tidy look by merging the cells with the same values. Also, the Auto-Merge feature simplifies the process of merging duplicate content in adjacent cells. It automatically merges rows or columns with the same value.
- Data Binding
Easily bind your worksheet to a data source of type IList, IEnumarable, or IBindingList. This dynamic capability ensures that your spreadsheet reflects real-time changes from the connected data source, enhancing data integration.
- Data Validation
Add data validation rules in cells to maintain accuracy, allowing only specific entries from a list of values or valid range of numbers.
- Conditional Format Rules
Use conditional formatting rules in cells and ranges to apply styles based on cell contents, making it easier to analyze the data. With icons, data bars, and color scales, this feature helps to quickly view table values.
- Formula Text Box
Enable efficient formula editing in the active cell and highlighting cell using the Formula Text Box to improve readability.
- Cell Styles
Customize the appearance of cells using built-in or custom styles, apply theme colors, different border styles, and also customize row and column header layouts with background colors, cell types, and text orientation.
- Built-in and Custom Themes
Apply a built-in theme or create a custom theme to customize the look of the spreadsheet. Themes allow consistent styling of elements like split boxes, filter buttons, drop-downs, and more.
- Print Reports to PDF
Design advanced reports that integrate tables, charts, and images, and print them directly or save as PDFs. The built-in print preview lets you adjust the layout before finalizing.