Protection using Aspose.Grid


#1

Hi,

I was wondering if anyone out there could help me. I am using Aspose.Grid to display a large number of database records on a web form. I then use the Aspose.Grid Save Command to generate an Excel spreadsheet.

this.GridWeb1.WebWorksheets.SaveToExcelFile(filename);

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader( "content-disposition","attachment; filename=book1.xls");

Response.WriteFile(filename);

Response.End();

I am trying to apply protection to the Excel spreadsheet when it opens on my pc. I can only get the protection to work on the grid as soon as I save the spreadsheet to my pc the protection is lost…

Please assist me as I have tried everything to no avail. A code sample would be greatly appreciated.

Thanks,

Sarah


#2

Hi,

The aspose.gird.web only support protect sheet/cells in web forms. We will add support for export protection information to Excel files in the next version. This will take us one or two weeks.

Thank you.