Export to Excel "SheetName" already exists

[Mark]

Is there something built into the export of the PivotTable to a Excel file to have to check for the name w/out throwing an error or better yet, have it auto Index it? 

 

Thanks

[Ralitsa]

Hi Mark,

Thank you for contacting us. 

You can create unique names of SheetName using number or date. Please refer to the code snippet below: 

PivotGridSpreadExport exporter;
SpreadExportRenderer exportRenderer;
int sheetNumber;

private void radButton1_Click(object sender, EventArgs e)
{
    sheetNumber++;
    exportRenderer = new SpreadExportRenderer();
    exporter = new PivotGridSpreadExport(this.radPivotGrid1);
    exporter.SheetName = "SpreadExport" + sheetNumber;
    exporter.ExportFormat = SpreadExportFormat.Xlsx;
    exporter.FileExportMode = FileExportMode.NewSheetInExistingFile;
    exporter.RunExport(@"..\..\file.xlsx", exportRenderer);
}

Another suggestion is to set the FileExportMode property to CreateOrOverrideFile which will override the specified file and it is not necessary to create unique name of sheet each time. 

Hope this will help you. Let me know if you have any other questions.

Regards,
Ralitsa
Telerik