H
hkosev
hi,
why I still get result 255 columns as I have approximately 280 in my
test1.xlsx
here is the code used
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\test1.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""";
string strSQL = "SELECT * FROM [test$]";
OleDbConnection excelConnection = new OleDbConnection
(connectionString);
OleDbCommand dbCommand = new OleDbCommand(strSQL,
excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter
(dbCommand);
System.Data.DataTable dTable = new System.Data.DataTable
();
dataAdapter.Fill(dTable);
Trace.WriteLine(dTable.Columns.Count.ToString
());
why I still get result 255 columns as I have approximately 280 in my
test1.xlsx
here is the code used
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\test1.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""";
string strSQL = "SELECT * FROM [test$]";
OleDbConnection excelConnection = new OleDbConnection
(connectionString);
OleDbCommand dbCommand = new OleDbCommand(strSQL,
excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter
(dbCommand);
System.Data.DataTable dTable = new System.Data.DataTable
();
dataAdapter.Fill(dTable);
Trace.WriteLine(dTable.Columns.Count.ToString
());