1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
string filePath = @"C:\Classeur1.xls";
objet passWord = "monPass";
_Application application = new ApplicationClass();
_Workbook workbook = application.Workbooks.Open(filePath, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
if(workbook.HasPassword)
{
workbook.Close(Type.Missing,Type.Missing,Type.Missing);
workbook = application.Workbooks.Open(filePath, Type.Missing,Type.Missing, Type.Missing, passWord, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
}
Excel._Workbook xlClasseur; |
Partager