Open password excel file , import C#

See more:

C#

MS-Excel

DataGridView

password

hello guys , in my own self study about import an excel file to my data grid view
within coding i tried to put password on the excel file, and i close it

i coded at the conncetion string like this

cn1.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + myPath + ";Extended Properties=" + "\"Excel 12.0 Xml;HDR=YES;IMEX=1\"";

(local connection string without password)

What I have tried:

and then i try with a password

cn1.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + myPath + ";Password=haha;Extended Properties=" + "\"Excel 12.0 Xml;HDR=YES;IMEX=1\"";

exception happens :

Quote:

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.