Changing Worksheet name while exporting to CSV

[Dhaval]

Hi All,

I am facing a situation here where I need to change the worksheet name of CSV file. I use below code to export my grid to CSV.

grid1.MasterTableView.ExportToCSV();

I don't want to export file to excel (i.e. xls or Excelml). I am using Telerik 2011 Q3. Is it possible to do the same in Telerik 2012 Q1?

Thanks in advance!!!

Dhaval Tamhane

[Shinu]

Hello,

Try setting the FileName as shown below.
C#:

radgrid1.ExportSettings.FileName = "Customer";

-Shinu.

[Dhaval]

Hi Shinu,

Thanks for your reply, but sorry that I was not more clear.

Actually my worksheet name is different than filename. If I give your code, then filename will be assigned to worksheet, but I don't want that.

Dhaval Tamhane

[Richard]

Dhaval:

As far as I know, it is not possible to change the sheet name out-of-the-box when using the CSV export format.

In order to do this you'd have to export to ExcelML and use the method specified in the How to set excel sheet name in Radgrid Export to excel function? forum thread.

Cheers!