C#中DataTable数据导出为HTML格式文件

 /// <summary>
/// DataTable导出为HTML的Table并保存到本地
/// </summary>
/// <param name="dt">需要导出的数据源</param>
/// <param name="filename">保存文件名</param>
private void exportDataTableToHtml(DataTable dt, string filename)
{
    StringBuilder strhtml = new StringBuilder();
    strhtml.Append("<!DOCTYPE html>");
    strhtml.Append("<html lang=\"en\">");
    strhtml.Append("<head>");
    strhtml.Append("<meta charset=\"utf-8\" />");
    strhtml.Append("<title>" + filename + "</title>");
    strhtml.Append("<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">");
    strhtml.Append("<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />");
    strhtml.Append("</head>");
    strhtml.Append("<body>");
    strhtml.Append("<table border=\"3\">");
    strhtml.Append("<tr>");
    foreach (DataColumn c in dt.Columns)
    {
        strhtml.Append("<td>");
        strhtml.Append(c.ColumnName);
        strhtml.Append("</td>");
    }
    strhtml.Append("</tr>");
    foreach (DataRow row in dt.Rows)
    {
        strhtml.Append("<tr>");
        foreach (DataColumn c in dt.Columns)
        {
            strhtml.Append("<td>");
            strhtml.Append(row[c.ColumnName].ToString());
            strhtml.Append("</td>");
        }
        strhtml.Append("</tr>");
    }
    strhtml.Append("</table>");
    strhtml.Append("</body>");
    strhtml.Append("</html>");
    string savefilename = System.Windows.Forms.Application.StartupPath + "\\" + filename + ".html";
    System.IO.File.WriteAllText(savefilename, strhtml.ToString());
}

posted @ 2023-06-02 15:12 xjournal 阅读(189) 评论(0) 编辑收藏举报

刷新页面返回顶部

登录后才能查看或发表评论，立即登录或者逛逛博客园首页

相关博文：

· MongoDB导入导出备份数据

· layui下拉框可手动输入

· C# 将DataTable 导出 CSV

· .NET 导出到excel

· C# 导出DataTable到Excel

2025年3月

日

一

二

三

四

五

六

xjournal

C#中DataTable数据导出为HTML格式文件

搜索

最新随笔

随笔分类

随笔档案

评论排行榜

推荐排行榜

	/// <summary>
	/// DataTable导出为HTML的Table并保存到本地
	/// </summary>
	/// <param name="dt">需要导出的数据源</param>
	/// <param name="filename">保存文件名</param>
	private void exportDataTableToHtml(DataTable dt, string filename)
	{
	StringBuilder strhtml = new StringBuilder();
	strhtml.Append("<!DOCTYPE html>");
	strhtml.Append("<html lang=\"en\">");
	strhtml.Append("<head>");
	strhtml.Append("<meta charset=\"utf-8\" />");
	strhtml.Append("<title>" + filename + "</title>");
	strhtml.Append("<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">");
	strhtml.Append("<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />");
	strhtml.Append("</head>");
	strhtml.Append("<body>");
	strhtml.Append("<table border=\"3\">");
	strhtml.Append("<tr>");
	foreach (DataColumn c in dt.Columns)
	{
	strhtml.Append("<td>");
	strhtml.Append(c.ColumnName);
	strhtml.Append("</td>");
	}
	strhtml.Append("</tr>");
	foreach (DataRow row in dt.Rows)
	{
	strhtml.Append("<tr>");
	foreach (DataColumn c in dt.Columns)
	{
	strhtml.Append("<td>");
	strhtml.Append(row[c.ColumnName].ToString());
	strhtml.Append("</td>");
	}
	strhtml.Append("</tr>");
	}
	strhtml.Append("</table>");
	strhtml.Append("</body>");
	strhtml.Append("</html>");
	string savefilename = System.Windows.Forms.Application.StartupPath + "\\" + filename + ".html";
	System.IO.File.WriteAllText(savefilename, strhtml.ToString());
	}