Create Excel file with Password protection In File Level

Navneet Singh

Hi Folks,

I want to create excel file from Datatable with Passward protection in file Level by C#. I want excel need to passward when Open. I am able to protect sheet level using closedXML dll. But not able to File level. Please help me on the same.

Thanks.

5 Replies

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

Liam Flink7y ago
It's a very normal matter for creating Excel file with password protection. You may try ZetExcel for complete your task. Just try it and get the results. Thanks
0
Navneet Singh8y ago
Hi Thanks for reply.

I checked for both options and it's not comptaiable with .net 4.5. I have compiled flatform .net 4.5. So i used both FreeSpire.XLS.7.8 and EPPlus higer version. I also try to comple source code from codeplex for EPPlus and there si lot's of error. try to figure out, but still there is lot's of error. Please suggest me how i will implement this solutions.
0
Leon D8y ago
Hi,

Check the blow links:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/NET-Protect-Excel-Protect-Excel-Workbook-and-Worksheet.html
0
Leon D8y ago
Hi,

Check the blow links:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/NET-Protect-Excel-Protect-Excel-Workbook-and-Worksheet.html
0
Jignesh Kumar8y ago
Hi Navneet,

Please find below link for the same,
https://www.c-sharpcorner.com/blogs/protecting-excel-files-programmatically
https://forums.asp.net/t/1818309.aspx?Export+Excel+with+password+protected+sheet+in+asp+net+c+
0