The WPF Spreadsheet control is an Excel-inspired control that allows you to create, edit, view, and format Microsoft Excel files without having Excel installed. It provides an integrated ribbon to cover any possible business scenario, maximizing its ease of use. It ships with a built-in calculation engine with support for more than 400 of the most widely used formulas. It is built on Essential XlsIO, which features a full-fledged object model similar to the Microsoft Office Automation libraries.
The Spreadsheet control for WPF is an Excel-inspired control which display and edit files based on all popular Excel file formats, including XLS and XLSX. You can even open a file in one format and save it to another format.
Load and manipulate Excel workbooks with a large amount of data and any number of worksheets in less time with minimal memory consumption.
The spreadsheet control provides a smooth scrolling experience even with many cells in a view.
The spreadsheet control has a fast and efficient calculation engine with more than 400 Excel functions.
Data editing comes with the ability to add, edit, and remove formulas in a cell. Users can also select the range reference directly using the mouse or keyboard while entering formulas, just like in Excel.
Validate the edited values based on the data validation rules defined for a cell or range of cells. Data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.
Undo and redo changes made in an Excel workbook. There is no limit to the number of undo and redo operations you can perform.
Clipboard operations with Excel-like paste options enable users to paste values or formulas with or without formatting.
Drag-fill allows users to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.
There’s built-in support for hyperlinks and bookmarks. Navigation through bookmarks to a specific cell or range of cells in a workbook is also supported as in Excel.
A wide range of formulas is available with cross-sheet references, named ranges, table formulas, and array formula support.
The built-in calculation engine is preloaded with more than 400 Excel-compatible functions covering a broad range of business scenarios.
Automatically recalculate values when a precedent cell is edited.
Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows you to add, edit, and delete names.
Import and modify various font formatting options like font size, font family, font styles, font color, and fill color.
Import and modify various alignments, merged cells, and wrap settings from Excel.
Import and modify number formats such as currency, percentage, short date, long date, time, fraction, scientific, and custom number formats similar to Excel.
Import table formats and predefined cell styles from Excel. You can also format a range as a table and define cell styles at runtime.
Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends.
Format the appearance of cells based on their value or the values of any other cells.
Use data bars to easily spot larger and smaller numbers.
Use color scales to understand data distribution and variations.
Icon sets distinguish data in three or five categories based on the threshold value.
Analyze data with automatic filtering and sorting.
Import outlines and group or ungroup rows and columns at runtime.
Import charts from Excel that can be defined at runtime. This helps visually enhance the represented data.
Import sparklines from excel to visually represent data in a row.
The spreadsheet control is touch-optimized for all user interactions, similar to Excel.
Select a range of cells, rows, columns, and tables. The spreadsheet control also supports all keyboard interactions with cell selections.
Import, add, edit, and delete cell comments.
Zoom in and out of worksheet contents. Plus, the zoom level can be imported and exported to and from Excel.
There’s built-in support for cell and tab context menus. Custom context menu items can also be added.
Search the data in a workbook and replace it efficiently with advanced search options. Also select all cells with formulas, conditional formatting, constants, and data validation.
Import and export data from various sources with the help of XlsIO as an intermediary.
Localize all static text in the ribbon and built-in dialogs to any desired language.