How to convert DateGrid to Word document?
We don't have direct API to convert DataGrid to word export. However, through workaround we can achieve this by enumerating all the records in the DataGrid and insert into the Word table using DocIO. Please refer the below code snippet to do so
C#
//Create a table
WTable doctable = new WTable(doc);
doc.LastSection.Tables.Add( doctable);
DataTable table = (DataTable)this.dataGridView1.DataSource;
//Enumerate each record in the Grid
for(int i=0;i
{
doctable.AddRow(true, false);
//Enumerate each cell in the record
for (int j = 0; j < table.Rows[1].ItemArray.Length; j++)
{
WTableCell cell = new WTableCell(doc);
cell.AddParagraph().AppendText(table.Rows[i].ItemArray.GetValue(j).ToString());
cell.Width = 50;
doctable.Rows[i+1].Cells.Add(cell);
}
}
VB
'Create a table
Dim doctable As WTable = New WTable(doc)
doc.LastSection.Tables.Add(doctable)
Dim table As DataTable = CType(Me.dataGridView1.DataSource, DataTable)
'Enumerate each record in the Grid
Do
doctable.AddRow(True, False)
'Enumerate each cell in the record
For j As Integer = 0 To table.Rows(1).ItemArray.Length - 1
Dim cell As WTableCell = New WTableCell(doc)
cell.AddParagraph().AppendText(table.Rows(i).ItemArray.GetValue(j).ToString())
cell.Width = 50
doctable.Rows(i+1).Cells.Add(cell)
Next j
Loop