//第一行是表头
private DataTable OpenCSVFile(string filepath)
{string strpath = filepath; //csv文件的路径
DataTable mycsvdt=new DataTable();
try
{
int intColCount = 0;
bool blnFlag = true;
DataColumn mydc;
DataRow mydr;
string strline;
string[] aryline;
StreamReader mysr = new StreamReader(strpath, System.Text.Encoding.Default);
while ((strline = mysr.ReadLine()) != null)
{
aryline = strline.Split(new char[] { ',' });
//datatable加上列名
if (blnFlag)
{
blnFlag = false;
intColCount = aryline.Length;
int col = 0;
for (int i = 0; i < aryline.Length; i++)
{
col = i + 1;
mydc = new DataColumn(aryline[i]);
mycsvdt.Columns.Add(mydc);
}
continue;
}
//填充数据并加入到datatable中
mydr = mycsvdt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i];
}
mycsvdt.Rows.Add(mydr);
}
mysr.Close();
return mycsvdt;
}
catch (Exception e)
{
Utility.PromptMsg("读取CSV文件中的数据出错." + e.Message);
return mycsvdt;
}
}