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