Protection using Aspose.Grid



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.


Response.ContentType = "application/";

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



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.





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.