This article explains how to add a RadSpreadsheet control to a page in your application.
It contains the following sections:
The assemblies that contain the implementation of RadSpreadsheet and must be referenced in order to use the control are:
For export and import to XLSX:
To export a document to PDF, you will need to add a reference to the corresponding assembly:
Note that in order to import/export in XLSX or export to PDF, the format provider must be registered manually. More information on Import/Export can be found here.
If you want to use the sample UI provided in our demos you should add this reference as well:
For a bare-bone Spreadsheet control, you only need a declaration of the telerik schema:
For the UI that enables the full-featured use of the control, you should also declare:
Then, all that is left is to add the Spreadsheet component to the page:
<telerik:RadSpreadsheet x:Name="radSpreadsheet" />
RadSpreadsheet is easy to integrate with all kinds of UI thanks to the commanding mechanism that it employs. If you would like to use the control with a RadRibbonView, which shows the full potential of the control, you can refer to the Spreadsheet UI topic that describes how you can take advantage of RadSpreadsheetRibbon.
To open a document, you need to import it and the export functionalities will help you to save one. To work with documents of the formats supported by RadSpreadsheet, you should use the format provider classes. For more information on the matter, please check the Import/Export topic.