# Getting Started with the Telerik WebForms Spreadsheet

This article will get you started in using the **RadSpreadsheet** control. It contains the following sections:

* [Assembly References](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/getting-started#assembly-references)

* [Creating a Simple RadSpreadsheet](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/getting-started#creating-a-simple-radspreadsheet)

* [Binding a RadSpreadsheet to a provider at runtime](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/getting-started#binding-a-radspreadsheet-to-a-provider-at-runtime)

## Assembly References

In order to use the **RadSpreadsheet** control in your project you need to add references to the following assemblies:

* **Telerik.Spreadsheet.Web.dll**
* **Newtonsoft.Json.dll**

### NuGet installation

The recommended way to add the spreadsheet dependency is to install the
following NuGet package:

```shell
dotnet add package Telerik.Spreadsheet.Web
```

The package provides the `Telerik.Spreadsheet.Web.dll` assembly. If your project references the former `Telerik.Web.Spreadsheet.dll` assembly, remove that reference and replace it with `Telerik.Spreadsheet.Web.dll`.

For more information, see the [Telerik.Spreadsheet.Web NuGet package](https://www.nuget.org/packages/Telerik.Spreadsheet.Web).

### Manual installation

You can also access the required assemblies from the `AdditionalLibraries/Bin462` folder in the Telerik UI for ASP.NET AJAX installation. When using the manual installation, reference:

* `Telerik.Spreadsheet.Web.dll`
* `Newtonsoft.Json.dll`

### SpreadsheetDocumentProvider dependencies

You can access the needed assemblies from the `AdditionalLibraries` folder in the **Telerik® UI for ASP.NET AJAX** installation (automated and manual) and from the internal builds archive. They support .NET 4 and .NET 4.5, so depending on the target framework of your project, you need to take the assemblies from the `Bin40` or the `Bin45` or the `Bin462` folder respectively.

The following assemblies are required in order to be able to use the control with the predefined [**SpreadsheetDocumentProvider**](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/data-binding/providers/using-a-data-provider) (applicable for most scenarios):

* **Telerik.Windows.Documents.Core.dll** — the main assembly from the Telerik document processing libraries.

* **Telerik.Windows.Zip.dll** — needed for working with zipped formats (DOCX, XLSX) and PDF.

* **Telerik.Windows.Documents.Spreadsheet.dll** — the main assembly for the spreadsheet processing. It is needed for processing XLSX, CSV, TXT documents.

* **Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll** — needed for processing XLSX documents.

> note You could find the above assemblies in the **AdditionalLibraries** folder of the installation directory on your machine (C:\Program Files\Progress\UI for ASP.NET AJAX RX YYYY).

## Creating a Simple RadSpreadsheet

To create a new instance of RadSpreadsheet on your page using the designer, you should follow the below steps:

* Drag a RadSpreadsheet control from the Toolbox onto your Web Page.

* The Smart Tag should appear automatically. Within the Smart Tag menu, from the Skin drop-down chose the desired Skin for this control:

  ![RadSpreadsheet Smart Tag with the Skin selector](https://www.telerik.com/products/aspnet-ajax/documentation/assets/99791cfab146370524331104c69e4cd9/spreadsheet-smart-tag.png "spreadsheet-overview")

* Run the application. You should see the newly created empty RadSpreadsheet on your page:

  ![New empty RadSpreadsheet control](https://www.telerik.com/products/aspnet-ajax/documentation/assets/fffd4aea5c233acdfe6db37d345fb0ce/new-empty-spreadsheet.png "spreadsheet-overview")

## Binding a RadSpreadsheet to a provider at runtime

Binding the RadSpreadsheet to a provider at runtime requires two simple steps:

* Create an excel file and copy it to the App_Data folder of your project. In this example we have created a file with a name "Spreadsheet.xlsx".

* Set the **Provider** property in the code behind, by assigning it an instance of the Telerik.Web.UI.SpreadsheetDocumentProvider class, with the path to the excel file as a parameter:

> caption Example: Bind RadSpreadsheet to an Excel file at runtime

```C#

protected void Page_Init(object sender, EventArgs e)
{
	// Load the workbook provider during initialization so it survives postbacks.
	RadSpreadSheet1.Provider = new SpreadsheetDocumentProvider(Server.MapPath("~/App_Data/Spreadsheet.xlsx"));
}
	
```

```VB

Protected Sub Page_Init(sender As Object, e As EventArgs)
	' Load the workbook provider during initialization so it survives postbacks.
	RadSpreadSheet1.Provider = New SpreadsheetDocumentProvider(Server.MapPath("~/App_Data/Spreadsheet.xlsx"))
End Sub

```

You have now bound your RadSpreadsheet using the Provider property at runtime:

![spreadsheet-overview](https://www.telerik.com/products/aspnet-ajax/documentation/assets/e50b87b52a484222abb8fb46baeaa187/spreadsheet-gettig-started-done.png "spreadsheet-overview")

## See Also

* [Overview](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/overview)

* [Known limitations](https://www.telerik.com/products/aspnet-ajax/documentation/controls/spreadsheet/troubleshooting/known-limitations)
