# SpreadExportRenderer

The **SpreadExportRenderer** class gives you access to the exported document and provides you with the ability to change it before it is saved.

The **SpreadExportRenderer** API gives you the ability to manipulate the document. The most important part is the **WorkbookCreated** event. This event is triggered on the **SpreadExportRenderer** object when the workbook is ready to be exported. Allows to introduce final customizations (for example you can add [header and footer](https://www.telerik.com/products/winforms/documentation/controls/gridview/features/exporting-data/how-to/add-header-and-footer-to-the-exported-document)). More information on how to work with Workbook is available here: [Working with Workbooks](http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-workbooks/create-open-and-save-workbooks).

The following example shows how you can subscribe to the event and use it to best fit the columns in the file:

 

 

```C#
          
SpreadExportRenderer exportRenderer = new SpreadExportRenderer();
exportRenderer.WorkbookCreated += exportRenderer_WorkbookCreated;

```

```VB.NET
Dim exportRenderer As New SpreadExportRenderer()
AddHandler exportRenderer.WorkbookCreated, AddressOf exportRenderer_WorkbookCreated

```

 

 

 

```C#
void exportRenderer_WorkbookCreated(object sender, WorkbookCreatedEventArgs e)
{
    Worksheet worksheet = (Worksheet)e.Workbook.Sheets[0];
    worksheet.Columns[worksheet.UsedCellRange].AutoFitWidth();
}

```

```VB.NET
Private Sub exportRenderer_WorkbookCreated(ByVal sender As Object, ByVal e As WorkbookCreatedEventArgs)
    Dim worksheet As Worksheet = CType(e.Workbook.Sheets(0), Worksheet)
    worksheet.Columns(worksheet.UsedCellRange).AutoFitWidth()
End Sub

```

 

![Telerik UI for WinForms SpreadExportRenderer exporting worksheet data](https://www.telerik.com/products/winforms/documentation/assets/97c71a80d4fae6e8b81f24c9bd22e2dc/tpf-export-data-support-spread-export-renderer001.png)

## See Also

* [PdfExportRenderer](https://www.telerik.com/products/winforms/documentation/telerik-presentation-framework/export-renderers/pdfexportrenderer)

* [SpreadStreamExportRenderer](https://www.telerik.com/products/winforms/documentation/telerik-presentation-framework/export-renderers/spreadstreamexportrenderer)