Edit this page
Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight

Getting Started

This article will get you started in using the RadSpreadProcessing library. It contains the following sections:

Assembly References

In order to use the model of the RadSpreadProcessing library in your project, you need to add references to the following assemblies:

  • Telerik.Windows.Documents.Core.dll
  • Telerik.Windows.Documents.Spreadsheet.dll

The following assemblies are required in order to be able to export to Xlsx and PDF formats:

  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll
  • Telerik.Windows.Documents.Fixed.dll
  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.dll
  • Telerik.Windows.Zip.dll

Creating a Workbook

The document model allows you to instantiate a new workbook and populate it with any data you want.

Example 1 shows how you can create a workbook and add a new worksheet to it.

[C#] Example 1: Create Workbook

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();

You can then create a CellSelection and set any value to the selected cells. Example 2 shows how you can create a cell and set a string value to it.

[C#] Example 2: Set value of cell

CellSelection selection = worksheet.Cells[1, 1]; //B2 cell
selection.SetValue("Hello RadSpreadProcessing");

Exporting

The RadSpreadProcessing library supports a variety of formats to which you can export the contents of a workbook. Example 3 shows how you can export the previously created workbook to Xlsx format.

[C#] Example 3: Export to Xlsx

string fileName = "SampleFile.xlsx";

IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();

using (Stream output = new FileStream(fileName, FileMode.Create))
{
    formatProvider.Export(workbook, output);
}

More information about the import and export functionalities of RadSpreadProcessing is available in the Formats and Conversion section.

Using RadSpreadsheet

RadSpreadsheet is a UI control part of the Telerik UI for WPF/Silverlight suites. The document model explained in this section of the documentation and all its features are shared between the RadSpreadProcessing library and RadSpreadsheet. This help section contains information about all UI-specific features of RadSpreadsheet.

See Also