长编号那一栏,50Z70406-2 这个就显示不了
代码如下:
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties=\"Excel 8.0;HDR=Yes\";" +
"data source=" + strPath;
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strConn);
Conn.Open();
string strSql = "select * from [" + strTable + "]";
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strSql, strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "table1");
Conn.Close();
return ds;
网上看了一下,有人说加上 IMEX=1 ,我试过还是没用
代码如下:
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties=\"Excel 8.0;HDR=Yes\";" +
"data source=" + strPath;
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strConn);
Conn.Open();
string strSql = "select * from [" + strTable + "]";
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strSql, strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "table1");
Conn.Close();
return ds;
网上看了一下,有人说加上 IMEX=1 ,我试过还是没用
"Extended Properties=\"Excel 8.0;HDR=Yes;IMEx=1\";" +
"data source=" + strPath;