Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

Spreadsheet

Spreadsheet is a control for viewing and editing Microsoft Excel files in a familiar Excel-like interface. It combines some of our most popular components, like our grid control, ribbon control, formula engine, and more, to create a first of its kind offering for Silverlight for viewing and editing Excel files.


Excel File Viewing and Editing

Spreadsheet allows you to import the contents of a Microsoft Excel (.xls or .xlsx) file, and it allows you to edit and save the Excel file. All the worksheets are imported and visualized in an interface that is identical to that of Excel’s tabbed interface. You can open protected worksheets and workbooks, and also encrypt them with passwords, if you want to. The following Excel versions are supported:

Excel 97, 2000, 2002, 2003 (.xls) Excel 2007, 2010 (.xlsx) Spreadsheet gives you all of this in a great Excel-like user interface, complete with Office-style ribbons and tabbed worksheets, even without Excel installed. The interactive UI allows you to edit or delete columns and rows at run time, add or remove sheets, access context menus, and more.


Styles and Formats

Styles and formats defined in an Excel file are automatically imported and applied on the cells, rows, and columns. End users can also apply these settings to the 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.


Ribbon Toolbar

The familiar, Excel-like ribbon toolbar gives your end users a wealth of command items that they can easily invoke in a familiar interface. It is fully customizable and you can easily add or remove items from it.


Layouts

Each worksheet is presented in a familiar Excel-like tabbed user interface. You can freeze panes so that specified columns and rows are always visible even while scrolling. Bookmarks and hyperlinks (to bookmarks) are also imported and presented to end users.


Formulas, Data Validation, and Comments

You can edit the contents of cells inline, including cells containing formulas. Solutions are not only calculated using the formulas already defined in the .xls file, but you can also define new formulas, save them in the .xls file, and calculate solutions with them. You can even specify cross-worksheet formulas. Validation rules specified in .xls files are automatically imported and end users can add to or edit the existing rules in familiar built-in dialog boxes. Comments for specific cells can be edited and also shown in smart tags that are identical to those used in Excel.


Named Ranges

The named ranges feature allows you to assign a name to a particular cell or range of cells. Named ranges are mainly used in formulas. They help you to easily identify the cell or range of cell references used in the formulas. Spreadsheet automatically imports the named ranges defined in Excel. Spreadsheet has a name manager that displays the existing named ranges in the workbook and also allows the end user to create, edit, and delete the named ranges.


Clipboard

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 get 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 them when the workbook has many worksheets. It allows the end user to insert, delete, and rename the worksheet. When the end user renames the worksheet, spreadsheet automatically updates all the formulas that have the old sheet name with the modified sheet name. You can protect worksheets to prevent unwanted changes from the end user. Spreadsheet can also import worksheets that are protected in Excel and allow you to unprotect them using the same password.


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.


Fully Localizable

The control comes with support for several built-in locales and 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.