Mar 02, 2018 04:13 PM|mgebhard|LINK
I am generating Excel file using Microsoft interop components. Is their any mechanism while creating the excel we can make this read-only worksheet in c#.
Office Interop should work since
Excel also has the read-only feature (MS Office). You'll need to search through the Interop docs to find the API or ask this question on the MS Office support forum. This is an ASP.NET support forum.
However, I must warn you that Office Interop on a web server is not recommended or supported by Microsoft. The reason is MS Office must be installed on the server, which is a security risk, and Interop actually opens Excel to perform the operations. This
can cause concurrency issues.
I suggest that you create a PDF which is, for the most part, read only.