Grid SaveToExcelFile

Aspose.Cells Product Family
1

I’m exporting a grid data to an XLS format. And I’m trying to hide the first worksheet. The following code doesn’t work. What am I doing wrong?

GridWeb1.WebWorksheets[0].Visible = false;

GridWeb1.WebWorksheets.SaveToExcelFile(filename);

Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

Please download and use the latest version:
Aspose.Cells
for GridWeb v2.7.7.2002
and let us know your feedback.

If you are using the evaluation version of Aspose.Cells for GridWeb, you cannot hide the evaluation worksheet.

Similarly, if you have a single worksheet, you cannot hide it.

If you are still facing problem due to some other reason, please share your sample code and source xls/xlsx file, we will look into it and help you asap.