c# 读取空行_c# – 从Excel读取时如何计算空行

我认为你的问题在于你的连接字符串.我测试了以下代码,它对我有用：

DataSet Contents = new DataSet();

using (OleDbDataAdapter adapter = new OleDbDataAdapter("select FirstName,LastName,Email,Mobile from [" + mySheet + "]", connection))

{

adapter.Fill(Contents,"MyTable");

}

foreach (DataRow content in Contents.Tables["MyTable"].Rows)

{

if (content[0].ToString() == "" && content[0].ToString() == "" && content[0].ToString() == "" && content[0].ToString() == "")

{

Console.WriteLine("Empty Row");

}

else

{

Console.WriteLine(content[0] + " | " + content[1] + " | " + content[2] + " | " + content[3]);

}

}

我的连接字符串是：

string cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Untitled 1.xls\";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";