Essential Spreadsheet is a control for viewing and editing Microsoft Excel files in a familiar Excel-like interface without Excel installed. It combines some of our most popular components like our Grid control, Ribbon control, formula engine, and others to create a first of its kind offering for WPF for viewing and editing Excel files.
Viewing and Editing Excel Files
Essential Spreadsheet allows you to import the contents of a Microsoft Excel (.xls or .xlsx) file and also allows you to edit and save the Excel file.
All worksheets are imported and visualized in the same Excel-like tabbed interface. Even protected worksheets and workbooks can be opened, and you can also encrypt them with a password of your own.
The following Excel versions are supported:
Excel 97, 2000, 2002, 2003 (.xls), Excel 2007, 2010 (.xlsx)
Essential Spreadsheet gives you all this in a great Excel-like user interface with Office-style ribbons and tabbed worksheets without Excel installed.
The interactive UI allows you to edit or delete columns and rows at run time, add or remove sheets, context menus, and more. It also provides built-in support for all the common clipboard operations and Undo / Redo operations.
Styles and Formats
Styles and formats defined in an Excel file are automatically imported and applied to the correct cells, rows, and columns. End users can also apply these settings to cells during run time.
Charts and Sparklines
Embedded elements like charts, sparklines, rich text content, and images defined in the Excel document can be shown in the spreadsheet.
Each worksheet is presented in a familar Excel-like tabbed user inteface. Freeze panes are available to make certain columns and rows always visible while scrolling. Bookmarks and hyperlinks (to bookmarks) are also imported and presented to the end user.
Cells, including cells containing formulas, can be edited inline. Formulas defined in .xls files are not only calculated, but you can also define new formulas and save them in the .xls file. You can even specify cross-worksheet formulas.
Validation rules specified in .xls files are automatically imported in Essential Spreadsheet, and end users can edit or add new rules through familiar, built-in dialog boxes.
Comments for specific cells can be edited and also shown in smart tags identical to those found in Excel.
The named ranges feature in Essential Spreadsheet makes it possible to assign a name to a particular range of cells. The spreadsheet has a name box in the formula bar for inserting new named ranges and to display existing named ranges. Named ranges are mainly used in formulas.
Essential SpreadSheet provides full support for all the clipboard operations like cut, copy, and paste. In the case of formula cells, you can either paste the cell values or the formulas.
Also the formula values are adjusted based on the relative cell references.
A familar Excel-like ribbon toolbar gives your end users a wealth of command items that they can easily invoke in a familiar interface. The toolbar is fully customizable and you can easily add items to or remove items from it.
The Spreadsheet control allows you to zoom in to get a close-up view of the cells and allows you to zoom out to view more cells at once by setting the zoom scale for the grid.
In addition to being able to export to Excel 97-2010 file formats, it is also possible to export to HTML, PDF, and image formats.
Essential Spreadsheet comes with support for several built-in locales and it also allows you to add custom locales if necessary.