Spreadsheet

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, 2007, 2010, 2013. 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.


Layouts

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.


Editing

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.


Named Ranges

Named Ranges feature allows you to assign a name to a particular cell or range of cells. Named ranges are mainly used in formulas. It helps you to easily identify the cell or range of cell references used in the formulas. Spreadsheet automatically imports the Named Ranges which are defined in excel. Spreadsheet has a Name Manager which displays the existing Named Ranges in the Workbook and also allows the end user to create, edit and delete the Named ranges.


Clipboard

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.


Worksheet Management

Spreadsheet allows you to manage the worksheets in a Workbook. That is, you can show/hide the worksheets to easily navigate between the worksheets when the workbook have many worksheets. It allows the end user to insert, delete and rename the worksheet. When the end user rename the worksheet, Spreadsheet automatically updates all the formula which having old sheet name with modified sheet name. You can protect the worksheet to prevent the unwanted changes from the end user. Essential Spreadsheet can import the Worksheet which are protected in Excel and allows you to unprotect it using the same password.


Ribbon Toolbar

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.


Zooming

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.


Export Options

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.


Localization Support

Essential Spreadsheet comes with support for several built-in locales and it also allows you to add custom locales if necessary.


You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.