C# Datatable匯出CSV演算法,c#datatable匯出csv
/// <summary>
/// 匯出資料到CSV檔案
/// </summary>
/// <param name="dtExportTable">需要匯出的datatable</param>
/// <param name="dicColumnsInfo">匯出的列字典,key datable中的列,value需要匯出的列名稱</param>
/// <param name="FilePath">匯出的檔案路徑</param>
public static void ExportCSV(DataTable dtExportTable, Dictionary<string, string> dicColumnsInfo,string FilePath)
{
List<string> notExist=new List<string>();
if(dtExportTable!=null&&dicColumnsInfo!=null)
{
foreach(string key in dicColumnsInfo.Keys)
{
if(!dtExportTable.Columns.Contains(key))
{
notExist.Add(key);
}
}
}
foreach(string key in notExist)
{
dicColumnsInfo.Remove(key);
}
for(int i=dtExportTable.Columns.Count-1;i>=0;i--)
{
string colName=dtExportTable.Columns[i].ColumnName;
if(!dicColumnsInfo.ContainsKey(colName))
{
dtExportTable.Columns.RemoveAt(i);
}
}
if (dtExportTable == null || dtExportTable.Columns.Count <= 0 || dtExportTable.Rows.Count <= 0 || dicColumnsInfo == null || dicColumnsInfo.Count <= 0 || string.IsNullOrEmpty(FilePath))
throw new Exception("匯出條件不滿足!");
StringBuilder sbResult=new StringBuilder();
int ColCount=dtExportTable.Columns.Count;
string Header=string.Empty;
for(int i=0;i<ColCount;i++)
{
if(String.IsNullOrEmpty(Header))
{
Header = dicColumnsInfo[dtExportTable.Columns[i].ColumnName];
}
else
{
Header += "," + dicColumnsInfo[dtExportTable.Columns[i].ColumnName];
}
}
sbResult.AppendLine(Header);//添加表頭
foreach(DataRow dr in dtExportTable.Rows)
{
string rowstring=string.Empty;
for(int i=0;i<ColCount;i++)
{
if(String.IsNullOrEmpty(rowstring))
{
rowstring=dr[i].ToString();
}
else
{
rowstring+=","+dr[i].ToString();
}
}
sbResult.AppendLine(rowstring); //添加行
}
File.WriteAllText(FilePath,sbResult.ToString());
}