当excel字段有内容而读不出来时候,尝试:
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
imex的意思:
0 is Export mode
1 is Import mode
2 is Linked mode (full update capabilities)
当excel字段有内容而读不出来时候,尝试:
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
imex的意思:
0 is Export mode
1 is Import mode
2 is Linked mode (full update capabilities)