cvs转datatable_c# 将csv文件转换datatable的三种方式。

string path ="test1.xlsx";

using (OleDbConnection conn = new OleDbConnection())

{

DataTable dt = new DataTable();

conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path+ ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1;MAXSCANROWS=0'";

using (OleDbCommand comm = new OleDbCommand())

{

comm.CommandText = "Select * from [" + "Sheet1" + "$]";

comm.Connection = conn;

using (OleDbDataAdapter da = new OleDbDataAdapter())

{

da.SelectCommand = comm;

da.Fill(dt);

dataGridView1.DataSource = dt;

}

}

}