XLS、XLSX、CSV 文件操作

XLS默认组件为2003：

XLSX下载组件：AccessDatabaseEngine2007 下载地址：https://dl.pconline.com.cn/download/1059627.html

DataTable dt = new DataTable();
string con = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + destFileName + ";Extended Properties=Excel 12.0";
//string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + destFileName + ";Extended Properties=Excel 8.0";
OleDbConnection conn = new OleDbConnection(con);
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataSet myDataSet = new DataSet();
try
{
    myCommand.Fill(myDataSet, "ExcelInfo");
    conn.Close();
    dt = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();    
}
catch (Exception ex)
{
    throw ex;
}

 连接字符串

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\folder\\excel2007.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

 “HDR =Yes;” 表示第一行包含列名，而不是数据。“HDR =No;” 表明相反;