Generate Excel file readonly using c#.net

Question

Hi All I want to create excel file which user can't edit. Also user not able to copy the contents of generated file. Is it possible in c#.net windows application

Alex Smith · Answer

Try this way to lock Excel sheet (make worksheet as read only): using Spire.Xls; namespace lock_excel_worksheet { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@..\lock worksheet.xls); workbook.Worksheets[0].Range.Style.Locked = true; workbook.Worksheets[1].Range.Style.Locked = true; workbook.SaveToFile(result.xls); } } } http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Lock-Easily-Lock-Excel-Worksheet-in-C-VB.NET.html

Abhay Shanker · Answer

Please check below urls http://stackoverflow.com/questions/19999531/how-to-create-readonly-excel-sheet-using-c-sharp-net http://stackoverflow.com/questions/18143393/how-to-createexport-excel-file-readonly-using-open-xml-2-5-sdk http://www.c-sharpcorner.com/forums/excel-how-to-make-read-only

Rajeesh Menoth · Answer

Hi Try this.. System.IO.FileInfo objFileInfo = new System.IO.FileInfo(szFilePath); objFileInfo.IsReadOnly = true ; Reference : http://www.codeproject.com/Questions/721389/How-to-make-an-excel-file-readonly-using-csharp http://stackoverflow.com/questions/8906670/how-to-open-excel-file-with-read-only-protection The answer is helpful.Then please accept it ..!!