6
Answers

How to use Password Protected Excel Sheet in c#

Vasu Gadhiya

Vasu Gadhiya
6y
9.5k
1
Hello

i used excel sheet for small data and it complete work.

but when i set password to excel sheet it cant'work.

------------------------
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + mypath + ";Password=test;Extended Properties=\"Excel 12.0;IMEX=0\"");
------------------------

I Want to use password protected excel sheet.

Thanks



Answers (6)
Next Recommended Forum