读取excel,遇到空cell的问题
如果所读取的excel中,某一行中包含 空cell,那么这个空值不会读取到myDataSet2中去。请问如何解决??(excel表的数据量较大)
例:如下excel
A1 B1 C1 D1
A2 C2 D2
我读到myDataSet2中的内容就是
A1 B1 C1 D1
A2 C2 D2
以下是我读取excel的代码
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ="+strExcelFileName+";Extended Properties='Excel 8.0;HDR=No;IMEX=1;'" ;
OleDbConnection myConn = new OleDbConnection(strCon);
string strSelectcmd = "select *";
strSelectcmd=strSelectcmd+" FROM [Sheet1$] ";
try
{
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strSelectcmd,myConn);
myDataSet2 = new DataSet() ;
myCommand.Fill(myDataSet2,"[Sheet1$]");
}
catch(Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
myConn.Close();
}