How to Open a password protected Excel File Using Interop

See more:

C#

interop

Hi,

I have a password protected Excel file and I need to read this file. To Open the file I'm using Microsoft Office Interop.Ecel dll and providing the below command. But still it is asking for the password as user prompt.



Could any one please help me in this issue.

using Excel = Microsoft.Office.Interop.Excel;

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); 

if (xlApp == null) 
{ 
Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");

return; 
}

string Password = "myPassword"; 
string Password_Unprotect = "UnProtectNow";
xlApp.DisplayAlerts = false; 
xlApp.Visible = false; 


Excel.Workbook wbk = xlApp.Workbooks.Open(@"D:\MyWorkbook.xlsb", 0, false, 5, Password, "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);

wbk.Password = Password; 
wbk.Unprotect(Password_Unprotect);

Thanks & Regards,
Mathi.