/// <summary>
/// //从csv读取数据返回table
/// </summary>
/// <param name="filePath"></param>
/// <param name="dt"></param>
/// <returns></returns>
static public bool readCSV(string filePath, out DataTable dt)//从csv读取数据返回table
{
dt = new DataTable();
try
{
System.Text.Encoding encoding = Encoding.Default;//GetType(filePath); //
// DataTable dt = new DataTable();
System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Open,
System.IO.FileAccess.Read);
System.IO.StreamReader sr = new System.IO.StreamReader(fs, encoding);
//记录每次读取的一行记录
string strLine = "";
//记录每行记录中的各字段内容
string[] aryLine = null;
string[] tableHead = null;
//标示列数
int columnCount = 0;
//标示是否是读取的第一行
bool IsFirst = true;
//逐行读取CSV中的数据
while ((strLine = sr.ReadLine()) != null)
{
if (IsFirst == true)
{
tableHead = strLine.Split(',');
IsFirst = false;
columnCount = tableHead.Length;
//创建列
for (int i = 0; i < columnCount; i++)
{
DataColumn dc = new DataColumn(tableHead[i]);
dt.Columns.Add(dc);
}
}
else
{
aryLine = strLine.Split(',');
DataRow dr = dt.NewRow();
for (int j = 0; j < columnCount; j++)
{
dr[j] = aryLine[j];
}
dt.Rows.Add(dr);
}
}
if (aryLine != null && aryLine.Length > 0)
{
dt.DefaultView.Sort = tableHead[0] + " " + "asc";
}
sr.Close();
fs.Close();
return true;
}
catch (Exception)
{
return false;
}
}
// 调用方法
string FilePath_3 = Application.StartupPath + "/test.CSV"; // csv文件地址
DataTable data = new DataTable();
readCSV(FilePath_3, out data); // 调用函数
// 遍历table 中的所有数据
for (int i = 0; i < data.Rows.Count; i++)
{
for (int j = 0; j < data.Columns.Count; j++)
{
object obj = data.Rows[i][j]; //i行j列的值
Console.WriteLine("mulRea11= {0}", obj);
}
}
注意:csv文件第一行是名称行,必须有,不能被遍历。从第二行开始遍历