DataTabel 转 CSV 文件

DataTabel 转 CSV 文件

 

public string DataTableToCsv(DataTable vContent, string vOutputFilePath)
{
    string result;
    try
    {
        if (File.Exists(vOutputFilePath))
        {
            File.Delete(vOutputFilePath);
        }
        StringBuilder stringBuilder = new StringBuilder();
        for (int i = 0; i < vContent.Columns.Count; i++)
        {
            stringBuilder.Append(vContent.Columns[i].ColumnName);
            stringBuilder.Append((i == vContent.Columns.Count - 1) ? "\n" : ",");
        }
        foreach (object obj in vContent.Rows)
        {
            DataRow dataRow = (DataRow)obj;
            for (int i = 0; i < vContent.Columns.Count; i++)
            {
                stringBuilder.Append(dataRow[i].ToString().Trim());
                stringBuilder.Append((i == vContent.Columns.Count - 1) ? "\n" : ",");
            }
        }
        File.WriteAllText(vOutputFilePath, stringBuilder.ToString(), Encoding.UTF8);
        result = "OK";
    }
    catch (Exception ex)
    {
        throw new Exception("DataTable to Xlsx : \n" + ex.Message);
    }
    return result;
}