How to lock Excel Sheet generated by ASP.NET from editing ? Prevent user from selecting cells in Excel using ASP.NET !

A day back I had a requirement where user should not be able to edit the Excel sheet generated by my ASP.NET application . The user should not be even able to select cells .Normally in Excel Sheet , we can achieve this by going to Tools -- > Protect Sheet in Office 2003 , Review --> Protect Sheet in office 2007 . But How to do this in ASP.NET ? How to protect Excel sheet from getting edited using ASP.NET ? How to lock Excel Sheet using ASP.NET ? For achieving it , Use the code below .

xlWorkSheet.Cells.Locked = true;
// Locks cells in a excel Sheet
xlWorkSheet.EnableSelection =
Microsoft.Office.Interop.Excel.XlEnableSelection.xlUnlockedCells;
// Restrics selecting to only unlocked cells
xlWorkSheet.Protect("admin",false,true,true,false,false,false,false,false,false,false,false,false,false,false,false);
// Protects you Excel sheet with unprotect Password admin and attributes
// similar to Checkboxes as shown in the figure .

Add the above code just before saving your Excel workbook . Now export your excel and try to open it . You will get a message like "Your excel is Protected and readonly . To unlock it blah blah blah .... you will be prompted for password....." .

You might love to read this ? How to remove 'Sys' is undefined ?

Cool na !! For more ASP.NET solutions , Subscribe to my feed or click here to get updates via email

Posted in: