How to save/export entire datagridview into worddocument-C#?

using Word = Microsoft.Office.Interop.Word; public void Export_Data_To_Word(DataGridView DGV, string filename)
{
if (DGV.Rows.Count != 0)
{
int RowCount = DGV.Rows.Count;
int ColumnCount = DGV.Columns.Count;
Object[,] DataArray = new object[RowCount + 1, ColumnCount + 1];
//add rows
int r = 0;
for (int c = 0; c <= ColumnCount - 1; c++)
{
for (r = 0; r <= RowCount - 1; r++)
{
DataArray[r, c] = DGV.Rows[r].Cells[c].Value;
}
//end row loop
}
//end column loop
Word.Document oDoc = new Word.Document();
oDoc.Application.Visible = true;
//page orintation
oDoc.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape;
dynamic oRange = oDoc.Content.Application.Selection.Range;
string oTemp = "";
for (r = 0; r <= RowCount - 1; r++)
{
for (int c = 0; c <= ColumnCount - 1; c++)
{
oTemp = oTemp + DataArray[r, c] + "\t";
}
}
//table format
oRange.Text = oTemp;
object Separator = Word.WdTableFieldSeparator.wdSeparateByTabs;
object ApplyBorders = true;
object AutoFit = true;
object AutoFitBehavior = Word.WdAutoFitBehavior.wdAutoFitContent;
oRange.ConvertToTable(ref Separator, ref RowCount, ref ColumnCount, Type.Missing, Type.Missing, ref ApplyBorders, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, ref AutoFit, ref AutoFitBehavior, Type.Missing);
oRange.Select();
oDoc.Application.Selection.Tables[1].Select();
oDoc.Application.Selection.Tables[1].Rows.AllowBreakAcrossPages = 0;
oDoc.Application.Selection.Tables[1].Rows.Alignment = 0;
oDoc.Application.Selection.Tables[1].Rows[1].Select();
oDoc.Application.Selection.InsertRowsAbove(1);
oDoc.Application.Selection.Tables[1].Rows[1].Select();
//header row style
oDoc.Application.Selection.Tables[1].Rows[1].Range.Bold = 1;
oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Name = "Tahoma";
oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Size = 14;
//add header row manually
for (int c = 0; c <= ColumnCount - 1; c++)
{
oDoc.Application.Selection.Tables[1].Cell(1, c + 1).Range.Text = DGV.Columns[c].HeaderText;
}
//table style
oDoc.Application.Selection.Tables[1].set_Style("Grid Table 4 - Accent 5");
oDoc.Application.Selection.Tables[1].Rows[1].Select();
oDoc.Application.Selection.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
//header text
foreach (Word.Section section in oDoc.Application.ActiveDocument.Sections)
{
Word.Range headerRange = section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;
headerRange.Fields.Add(headerRange, Word.WdFieldType.wdFieldPage);
headerRange.Text = "your header text";
headerRange.Font.Size = 16;
headerRange.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
}
//save the file
oDoc.SaveAs2(filename);
//NASSIM LOUCHANI
}
}
private void button_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Word Documents (*.docx)|*.docx";
sfd.FileName = "export.docx";
if (sfd.ShowDialog() == DialogResult.OK)
{
Export_Data_To_Word(dataGridView1, sfd.FileName);
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Balaji Suvarnkar6y ago
Accepted answer
1. using Word = Microsoft.Office.Interop.Word; public void Export_Data_To_Word(DataGridView DGV, string filename)
2. {
3. if (DGV.Rows.Count != 0)
4. {
5. int RowCount = DGV.Rows.Count;
6. int ColumnCount = DGV.Columns.Count;
7. Object[,] DataArray = new object[RowCount + 1, ColumnCount + 1];
8. //add rows
9. int r = 0;
10. for (int c = 0; c <= ColumnCount - 1; c++)
11. {
12. for (r = 0; r <= RowCount - 1; r++)
13. {
14. DataArray[r, c] = DGV.Rows[r].Cells[c].Value;
15. }
16. //end row loop
17. }
18. //end column loop
19. Word.Document oDoc = new Word.Document();
20. oDoc.Application.Visible = true;
21. //page orintation
22. oDoc.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape;
23. dynamic oRange = oDoc.Content.Application.Selection.Range;
24. string oTemp = "";
25. for (r = 0; r <= RowCount - 1; r++)
26. {
27. for (int c = 0; c <= ColumnCount - 1; c++)
28. {
29. oTemp = oTemp + DataArray[r, c] + "\t";
30. }
31. }
32. //table format
33. oRange.Text = oTemp;
34. object Separator = Word.WdTableFieldSeparator.wdSeparateByTabs;
35. object ApplyBorders = true;
36. object AutoFit = true;
37. object AutoFitBehavior = Word.WdAutoFitBehavior.wdAutoFitContent;
38. oRange.ConvertToTable(ref Separator, ref RowCount, ref ColumnCount, Type.Missing, Type.Missing, ref ApplyBorders, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, ref AutoFit, ref AutoFitBehavior, Type.Missing);
39. oRange.Select();
40. oDoc.Application.Selection.Tables[1].Select();
41. oDoc.Application.Selection.Tables[1].Rows.AllowBreakAcrossPages = 0;
42. oDoc.Application.Selection.Tables[1].Rows.Alignment = 0;
43. oDoc.Application.Selection.Tables[1].Rows[1].Select();
44. oDoc.Application.Selection.InsertRowsAbove(1);
45. oDoc.Application.Selection.Tables[1].Rows[1].Select();
46. //header row style
47. oDoc.Application.Selection.Tables[1].Rows[1].Range.Bold = 1;
48. oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Name = "Tahoma";
49. oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Size = 14;
50. //add header row manually
51. for (int c = 0; c <= ColumnCount - 1; c++)
52. {
53. oDoc.Application.Selection.Tables[1].Cell(1, c + 1).Range.Text = DGV.Columns[c].HeaderText;
54. }
55. //table style
56. oDoc.Application.Selection.Tables[1].set_Style("Grid Table 4 - Accent 5");
57. oDoc.Application.Selection.Tables[1].Rows[1].Select();
58. oDoc.Application.Selection.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
59. //header text
60. foreach (Word.Section section in oDoc.Application.ActiveDocument.Sections)
61. {
62. Word.Range headerRange = section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;
63. headerRange.Fields.Add(headerRange, Word.WdFieldType.wdFieldPage);
64. headerRange.Text = "your header text";
65. headerRange.Font.Size = 16;
66. headerRange.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
67. }
68. //save the file
69. oDoc.SaveAs2(filename);
70. //NASSIM LOUCHANI
71. }
72. }
73. private void button_Click(object sender, EventArgs e)
74. {
75. SaveFileDialog sfd = new SaveFileDialog();
76. sfd.Filter = "Word Documents (*.docx)|*.docx";
77. sfd.FileName = "export.docx";
78. if (sfd.ShowDialog() == DialogResult.OK)
79. {
80. Export_Data_To_Word(dataGridView1, sfd.FileName);
81. }
82. }