/// <summary>
/// 导出报表为Csv
/// </summary>
/// <param name="dt">DataTable</param>
/// <param name="tableName">表名</param>
/// <param name="tableheader">表头</param>
/// <param name="columname">字段标题,逗号分隔</param>
public static bool DataTableToCSV(DataTable dt, string tableName, string tableheader, string columname)
{
if (!Directory.Exists("D:" + "\\" + "数据报表"))
{
Directory.CreateDirectory("D:" + "\\" + "数据报表");
}
if (!Directory.Exists("D:" + "\\" + "数据报表" + "\\" + "测试记录"))
{
Directory.CreateDirectory("D:" + "\\" + "数据报表" + "\\" + "测试记录");
}
string strFilePath = @"D:/数据报表/测试记录/" + tableName + ".csv";
try
{
string strBufferLine = "";
StreamWriter strmWriterObj = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);
//strmWriterObj.WriteLine(tableheader);
strmWriterObj.WriteLine(columname);
for (int i = 0; i < dt.Rows.Count; i++)
{
strBufferLine = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
if (j > 0)
strBufferLine += ",";
strBufferLine += dt.Rows[i][j].ToString();
}
strmWriterObj.WriteLine(strBufferLine);
}
strmWriterObj.Close();
return true;
}
catch
{
return false;
}
}
dataGridView 导出数据--CSV导出
于 2024-07-16 09:18:57 首次发布