/// <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());
}Ｃ＃ Datatable导出CSV算法
原文：http://blog.csdn.net/devgis/article/details/42422793
