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
4 comments:
If you're like most modern consumers, you probably can’t afford to spend an entire paycheck on a replica handbags . For high fashion on a budget, turn to Top 1 Handbags. We specialize in meticulous replications of some of the most popular replica louis vuitton , wallets, replica bags , and other accessories. Each replica handbags is meticulously crafted to ensure years of reliable, handsome service.
nice article..Realy helpful
in my web application i need to export data to excel from datatable in a particular format
this has been done
i need to lock some cells range to prevent editing in excel sheet
i tried but it doesnot get locked
ExcApp = New Excel.Application
ExcWS = ExcApp.Worksheets("SHEET1")
ExcWS.Range("A1", "C3").Locked = True
ExcWS.Protect(False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False)
i have above
2) i need to display checkbox against each supplier no displayed in the sheet
& when few of the suppliers are checked , need to import the checked data in the database
jordan shoes
stephen curry shoes
bape
off white shoes
nike lebron 16
russell westbrook shoes
steph curry shoes
moncler jackets
off white
kevin durant shoes
Post a Comment