我用上面下面的方法打开xls文件:
string StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection MyConn = new OleDbConnection(StrConn);
// MyConn.Open();
string StrExcel = "";
OleDbDataAdapter MyCommand = null;
DataSet ds = null;
StrExcel = "select * from [sheet1$]";
MyCommand = new OleDbDataAdapter(StrExcel, StrConn);
ds = new DataSet();
MyCommand.Fill(ds, "table1");
//MyConn.Close();
return ds.Tables["table1"];
但是table1第一行从第二列开始变成了F2,F3,F4,是怎么回事啊.
string StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection MyConn = new OleDbConnection(StrConn);
// MyConn.Open();
string StrExcel = "";
OleDbDataAdapter MyCommand = null;
DataSet ds = null;
StrExcel = "select * from [sheet1$]";
MyCommand = new OleDbDataAdapter(StrExcel, StrConn);
ds = new DataSet();
MyCommand.Fill(ds, "table1");
//MyConn.Close();
return ds.Tables["table1"];
但是table1第一行从第二列开始变成了F2,F3,F4,是怎么回事啊.
"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR=NO'";HDR=NO'为第一行数据不为列名