/// <summary>
/// DataGridView数据导出Word文档
/// </summary>
/// <param name="srcDgvs"></param>
/// <param name="fileName"></param>
//导出数据,传入一个datagridview和一个文件路径
public void ExportData(DataGridView srcDgvs, string fileName)
{
DataGridView srcDgv;
srcDgv = srcDgvs;
//保存Word文件
object path = fileName;
//建立表格
Word.Table table = m_Document.Tables.Add(m_Document.Paragraphs.Last.Range,
srcDgv.Rows.Count + 1, srcDgv.Columns.Count, ref missing, ref missing);
try
{
//设置标题
for (int i = 0; i < srcDgv.Columns.Count; i++)
{
table.Cell(0, i + 1).Range.Text = srcDgv.Columns[i].HeaderText;
}
//填充数据
for (int i = 0; i < srcDgv.Rows.Count; i++)
{
for (int j = 0; j < srcDgv.Columns.Count; j++)
{
table.Cell(i + 2, j + 1).Range.Text = srcDgv[j, i].Value.ToString();
}
}
m_Document.SaveAs(ref path, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing);
m_Document.Close(ref missing, ref missing, ref missing);
}
catch { }
finally
{
m_WordApp.Quit(ref missing, ref missing, ref missing);
}
}
DataGridView数据导出Word文档
最新推荐文章于 2023-06-07 17:05:01 发布