作者：乔山办公网日期：
返回目录：excel表格制作
StringBuilder strHtml = new StringBuilder();
strHtml.Append("<head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"></head>");
strHtml.Append("<table width='100%' border='1' cellpadding='5' cellspacing='1'>");
strHtml.Append("<tr><th colspan=" + dgv.Columns.Count + ">" + m_strTitle + "</th></tr>");
strHtml.Append("<tr bgcolor='#FF8000'>");
for (int i = 0; i < dgv.Columns.Count; i++)
{
strHtml.Append("<th>" + dgv.Columns[i].HeaderText + "</th>");
}
strHtml.Append("</tr>");
for (int i = 0; i < dgv.Rows.Count; i++)
{
strHtml.Append("<tr>");
for (int j = 0; j < dgv.Columns.Count; j++)
{
string td = "<td " + ((dgv.Rows[i].Cells[j].Value is string && m_stringFormat.Contains(j)) ? " style=\"vnd.ms-excel.numberformat: @\"" : "") + ">" + (dgv.Rows[i].Cells[j].Value != null ? dgv.Rows[i].Cells[j].Value.ToString() : "") + "</td>";
strHtml.Append(td);
}
strHtml.Append("</tr>");
}
strHtml.Append("</table>");
System.IO.File.WriteAllBytes(m_strFilename, System.Text.Encoding.UTF8.GetBytes(strHtml.ToString()));
-------------------------
修改上面的 td th 等等，定义<table>即可.
dgv 是DataGridView 控件. 都是7a64e4b893e5b19e333类似的