Create Excel file with Password protection In File Level

Question

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.

Liam Flink · Answer

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

Navneet Singh · Answer

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.

Leon D · Answer

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

Leon D · Answer

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

Jignesh Kumar · Answer

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+