System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("select * from [" + sheetName + "$] where F1 is not null ", con);

/// C#中获取Excel文件的表名

众生皆敬畏与探索。

public static List getExcelFileInfo(string pathName)

apt.Fill(dt);