We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to convert DateGrid to Word document?

Platform: WinForms |
Control: DocIO |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

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

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon