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.

24 Comments

Join the conversation! Your thoughts help the community grow.

Subash9y ago
Please share the output screenshot for understand fully thank you
Bhuvanesh Mohankumar10y ago
Good one...
Bhuvanesh Mohankumar10y ago
Nice
Arul R10y ago
Nice share
Mohammed Ibrahim11y ago
Thank you all...
Rakesh11y ago
Good work
Yashwanth Muthineni11y ago
Nice Share
Santhakumar Munuswamy11y ago
Nice Article. Thanks for sharing
Sumit Joshi11y ago
Nice share...thanks
- Mohammed Ibrahim11y ago
  thank you
Vaikesh K P11y ago
Good Share
- Mohammed Ibrahim11y ago
  thank you
Chervine Bhiwoo11y ago
Good one
- Mohammed Ibrahim11y ago
  thank you
Rajeesh Menoth11y ago
Good One
- Mohammed Ibrahim11y ago
  thank you
Nilesh Jadav11y ago
Nice one sir
- Mohammed Ibrahim11y ago
  thank you
Gopi Chand11y ago
Well done
- Mohammed Ibrahim11y ago
  thank you
Karthikeyan K11y ago
Good one
- Mohammed Ibrahim11y ago
  thank you
Pankaj Kumar Choudhary11y ago
Nice Explain Sir..........
- Mohammed Ibrahim11y ago
  thank you