How to use Password Protected Excel Sheet in c#

Oct 27 2013 1:26 AM

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