I am using open xml sdk to export excel. I get the excel file and copying that file to another place and then I'm inserting new rows with the data.
I should make that rows as read only (or I've to lock) using open xml sdk..
How to do that ?
excelexport-to-excelopenxmlopenxml-sdk
I am using open xml sdk to export excel. I get the excel file and copying that file to another place and then I'm inserting new rows with the data.
I should make that rows as read only (or I've to lock) using open xml sdk..
How to do that ?
Best Answer
I've referred the following link Excel File Password Protection with Open XML SDK.
Here I gave you full code to open the file from directory and insert cells. Here I've inserted only one cell. You can insert as you want. Here I've inserted locked cells. Find this one, it'll very helpful to you..
Note : Here I've mentioned the code only to read the existing file and insert the row and cells and lock the cells which have been inserted manually
Thank you.