I have to use OleDbConnection to create a new excel file, but when I open connection with this string:
OleDbConnection excelConnection =
new OleDbConnection(
开发者_Python百科 String.Format(
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Mode=ReadWrite;Extended Properties=""Excel 12.0;HDR=YES"";",
excelFile));
I receive an error that in english sounds like "The outer table is not in the expected format."
But the file is NEW and empty ... how can i do?
I have changed to ExcelPackage library, and now it works.
精彩评论