I want DataGridview details to be exported as Word file.

Manish Parmar

I am using Spire.Doc to export datagridview data to word, i am using below code, the problem is dont want to declare the array size it should be auto calculated as per the Rows of the Datagridview

Can anyone help me on the below where i can later add more than 1 Datagridview details also....

using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
Document doc = new Document();
Section section = doc.AddSection();
Spire.Doc.Table table3 = section.AddTable(true);
String[] Header3 = { "Column1", "Column2" };
String[][] data3 = new String[4][];
for (int k = 0; k < 4; k++)
{
data3[k] = new string[this.DataGridView.ColumnCount];
for (int j = 0; j < this.DataGridView.ColumnCount; j++)
{
data3[k][j] = this.DataGridView.Rows[k].Cells[j].Value.ToString();
}
}
//Add Cells
table3.ResetCells(data3.Length + 1, Header3.Length);
table3.TableFormat.Borders.Horizontal.LineWidth = 1;
table3.TableFormat.Borders.Vertical.LineWidth = 1;
//Header Row
Spire.Doc.TableRow FRow3 = table3.Rows[0];
FRow3.IsHeader = true;
//Row Height
FRow3.Height = 23;
for (int i = 0; i < Header3.Length; i++)
{
//Cell Alignment
Paragraph p1 = FRow3.Cells[i].AddParagraph();
FRow3.Cells[i].CellFormat.VerticalAlignment = VerticalAlignment.Middle;
p1.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
//Data Format
TextRange TR = p1.AppendText(Header3[i]);
TR.CharacterFormat.FontName = "Century Gothic";
TR.CharacterFormat.FontSize = 13;
//TR.CharacterFormat.TextColor = Color.Teal;
TR.CharacterFormat.Bold = true;
}
//Data Row
for (int r = 0; r < data3.Length; r++)
{
Spire.Doc.TableRow DataRow = table3.Rows[r + 1];
//Row Height
DataRow.Height = 20;
//C Represents Column.
for (int c = 0; c < data3[r].Length; c++)
{
//Cell Alignment
DataRow.Cells[c].CellFormat.VerticalAlignment = VerticalAlignment.Middle;
//Fill Data in Rows
Paragraph p2 = DataRow.Cells[c].AddParagraph();
TextRange TR2 = p2.AppendText(data3[r][c]);
//Format Cells
p2.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
TR2.CharacterFormat.FontName = "Century Gothic";
TR2.CharacterFormat.FontSize = 12;
//TR2.CharacterFormat.TextColor = Color.Brown;
}
}
doc.SaveToFile("OperateWord.docx", FileFormat.Docx);
System.Diagnostics.Process.Start("OperateWord.docx");

2 Replies

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

Manish Parmar6y ago
Thank you worked well..
0
Leon D6y ago
Refer the below code snippet to export DataGridView to word without declaring the array size.
static void Main(string[] args)
  {
      Document document = new Document();
      Section section = document.AddSection();
      //Convert data from datagridview to datatable
      DataTable dt = GetDgvToTable(this.dataGridView1);
      //Add table
      Spire.Doc.Table table = section.AddTable(true);
      table.ResetCells(dt.Rows.Count, dt.Columns.Count);
      //Add DataTable data to Word table
      for (int row = 0; row < dt.Rows.Count; row++)
      {
          TableRow dataRow = table.Rows[row];
          object[] datas = dt.Rows[row].ItemArray;
          for (int m = 0; m < datas.Length; m++)
          {
              dataRow.Cells[m].CellFormat.VerticalAlignment = VerticalAlignment.Middle;
              Paragraph para= dataRow.Cells[m].AddParagraph();
              TextRange textR = para.AppendText(datas[m].ToString());
              para.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
              textR.CharacterFormat.FontName = "Century Gothic";
              textR.CharacterFormat.FontSize = 12;
          }
      }
      //Save docx file
      document.SaveToFile("Sample1.docx", Spire.Doc.FileFormat.Docx);
  }
  public DataTable GetDgvToTable(DataGridView dgv)
  {
      DataTable dt = new DataTable();
      //Add row for header text
      DataRow headerRow = dt.NewRow();
      //Column
      for (int count = 0; count < dgv.Columns.Count; count++)
      {
          string headtext = dgv.Columns[count].HeaderText;
          DataColumn dc = new DataColumn(headtext);
          dt.Columns.Add(dc);
          headerRow[count] = headtext;
      }
      dt.Rows.Add(headerRow);
      //Row
      for (int count = 0; count < dgv.Rows.Count; count++)
      {
          DataRow dr = dt.NewRow();
          for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
          {
              dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);
          }
          dt.Rows.Add(dr);
      }
      return dt;
  }
0