Export GridView Using OpenXML Part 1

Hi guys. In this article I will show how to export a GridView table into a document using the Open XML.

Download the OPENXML using this location http://www.microsoft.com/en-in/download/details.aspx?id=30425.

After downloading the SDK install the .exe into your PC.

Now open a new project in your C# tool.

Add the OpenXML SDK reference to your project. Also include Windowsbase in the references.

Now use the following namespace in the code.

using DocumentFormat.OpenXml.Wordprocessing;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml;
using System.IO.Packaging;

After including the preceding namespace, design your table using the XML file. Mine looks as in the following.



Figure 1: Design Table

Add the data to the DataGridView.

Now create the document template using the following code:

//count number of column available in Gridview
int columncount = dataGridView1.Columns.Count;
using(WordprocessingDocument wpc = WordprocessingDocument.Create(filename, WordprocessingDocumentType.Document)) {
    // Add a new main document part.
    MainDocumentPart mainPart = wpc.AddMainDocumentPart();
    //Create DOM tree for simple document.
    mainPart.Document = new Document();
    // Save changes to the main document part.
    Body body = new Body();
    Table table = new Table();
    // Create a TableProperties object and specify its border information.
    TableProperties tblProp = new TableProperties(
    new TableBorders(
    new TopBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    },
    new BottomBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    },
    new LeftBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    },
    new RightBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    },
    new InsideHorizontalBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    },
    new InsideVerticalBorder() {
        Val = new EnumValue < BorderValues > (BorderValues.BasicBlackDots), Size = 20
    }));
    // Append the TableProperties object to the empty table.
    table.AppendChild < TableProperties > (tblProp);
    // Create a row.
    TableRow tr = new TableRow();
    //create Dynamic object by using array.
    TableCell[] tc1 = new TableCell[5];
    // this loop allow us to create multiple column according to the Gridview
    for (int i = 0; i < columncount; i++) {
        string[] columnhead = new string[columncount];
        columnhead[i] = dataGridView1.Columns[i].HeaderText.ToString();
        // Create a cell.
        tc1[i] = new TableCell();
        // Specify the width property of the table cell.
        tc1[i].Append(new TableCellProperties(
        new TableCellWidth() {
            Type = TableWidthUnitValues.Dxa, Width = "2400"
        }));
        // Specify the table cell content.
        tc1[i].Append(new Paragraph(new Run(new Text(columnhead[i]))));
        // Append the table cell to the table row.
        tr.Append(tc1[i]);
    }
    // Append the table row to the table.
    table.Append(tr);
    body.Append(table);
    mainPart.Document.Append(body);
    mainPart.Document.Save();

 Then open the document and pass the data in the GridView using the following code.

int rowcount = dataGridView1.Rows.Count;
int columncount = dataGridView1.Columns.Count;
{
    using(WordprocessingDocument doc = WordprocessingDocument.Open(filename, true)) {
        // Create an empty table.
        Table table = new Table();
        // Create a TableProperties object and specify its border information.
        TableProperties tblProp = new TableProperties(
        new TableBorders(
        new TopBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        },
        new BottomBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        },
        new LeftBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        },
        new RightBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        },
        new InsideHorizontalBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        },
        new InsideVerticalBorder()
        {
            Val = new EnumValue < BorderValues > (BorderValues.BasicThinLines), Size = 20
        }));
        // Append the TableProperties object to the empty table.
        table.AppendChild < TableProperties > (tblProp);
        for (int i = 0; i < rowcount; i++)
        {
            // Create a row.
            TableRow tr = new TableRow();
            // Create a cell.
            TableCell[] tc1 = new TableCell[columncount];
            for (int j = 0; j < columncount; j++)
            {
                tc1[j] = new TableCell();
                string data1 = dataGridView1.Rows[i].Cells[j].Value.ToString();
                // Specify the width property of the table cell.
                tc1[j].Append(new TableCellProperties(
                new TableCellWidth()
                {
                    Type = TableWidthUnitValues.Dxa, Width = "2400"
                }));
                // Specify the table cell content.
                tc1[j].Append(new Paragraph(new Run(new Text(data1))));
                tr.Append(tc1[j]);
            }
            // Append the table row to the table.
            table.Append(tr);
        }
        // Append the table to the document.
        doc.MainDocumentPart.Document.Body.Append(table);
        doc.Close();
    }
}

Design the table as you wish.

And have fun by using the OpenXML.