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;

}

 连接字符串

?

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

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