Vasu Gadhiya

Vasu Gadhiya

  • 1.8k
  • 429
  • 99.7k

How to use Password Protected Excel Sheet in c#

Oct 27 2013 1:26 AM

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.


Answers (7)