Generate Excel file readonly using c#.net

Pravin Ghadge

10y5.4kLearn iOS Programming

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Hi Pravin

Please find below link
https://social.msdn.microsoft.com/Forums/vstudio/en-US/f89fe6b3-68c0-4a98-9522-953cc5befb34/how-to-make-a-excel-cell-readonly-by-c-code?forum=vsto

https://forum.aspose.com/t/how-to-make-excel-workbook-readonly/34215/6
Alex Smith10y ago
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 Shanker10y ago
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 Menoth10y ago
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..!!