In this port “Asp.net export DataTable
to Word Document”, we shall see how to export content from a DataTable to a
Word Document.
Exporting content to Word is a common
feature, often seen in reporting modules, there are many ways of exporting
details to work, here we shall see a simple technique, of reading the
content in a DataTable and exporting it to Word by setting the Content-Type.
This method of exporting is very handy
since it allows doing any kind of formatting to the Word Document using the HTML tags.
Get
the data to be exported into a DataTable, add a Button to the Asp.Net page and
in the click event of the Button add the following code to export the content.
//
//
protected void
cmdExport_Click(object sender, EventArgs e)
{
// Add logic to get the data
to be exported into the DataTable dtReportData
GenerateWord(dtReportData);
GenerateWord(dtReportData);
}
//
public static void GenerateWord(DataTable
dtSource)
{
StringBuilder
sbDocBody = new StringBuilder();
;
try
{
// Declare
Styles
sbDocBody.Append("<style>");
sbDocBody.Append(".Header {
background-color:Navy; color:#ffffff;
font-weight:bold;font-family:Verdana; font-size:12px;}");
sbDocBody.Append(".SectionHeader { background-color:#8080aa;
color:#ffffff; font-family:Verdana; font-size:12px;font-weight:bold;}");
sbDocBody.Append(".Content { background-color:#ccccff; color:#000000;
font-family:Verdana; font-size:12px;text-align:left}");
sbDocBody.Append(".Label { background-color:#ccccee; color:#000000;
font-family:Verdana; font-size:12px; text-align:right;}");
sbDocBody.Append("</style>");
//
StringBuilder
sbContent = new StringBuilder();
;
sbDocBody.Append("<br><table align=\"center\"
cellpadding=1 cellspacing=0 style=\"background-color:#000000;\">");
sbDocBody.Append("<tr><td
width=\"500\">");
sbDocBody.Append("<table width=\"100%\"
cellpadding=1 cellspacing=2 style=\"background-color:#ffffff;\">");
//
if
(dtSource.Rows.Count > 0)
{
sbDocBody.Append("<tr><td>");
sbDocBody.Append("<table width=\"600\"
cellpadding=\"0\" cellspacing=\"2\"><tr><td>");
//
// Add
Column Headers
sbDocBody.Append("<tr><td
width=\"25\"> </td></tr>");
sbDocBody.Append("<tr>");
sbDocBody.Append("<td> </td>");
for
(int i = 0; i < dtSource.Columns.Count;
i++)
{
sbDocBody.Append("<td class=\"Header\"
width=\"120\">" +
dtSource.Columns[i].ToString().Replace(".",
"<br>") + "</td>");
}
sbDocBody.Append("</tr>");
//
// Add
Data Rows
for
(int i = 0; i < dtSource.Rows.Count;
i++)
{
sbDocBody.Append("<tr>");
sbDocBody.Append("<td> </td>");
for
(int j = 0; j < dtSource.Columns.Count;
j++)
{
sbDocBody.Append("<td class=\"Content\">"
+ dtSource.Rows[i][j].ToString() + "</td>");
}
sbDocBody.Append("</tr>");
}
sbDocBody.Append("</table>");
sbDocBody.Append("</td></tr></table>");
sbDocBody.Append("</td></tr></table>");
}
//
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer
= true;
//
HttpContext.Current.Response.AppendHeader("Content-Type", "application/msword");
HttpContext.Current.Response.AppendHeader("Content-disposition", "attachment; filename=EmployeeDetails.doc");
HttpContext.Current.Response.Write(sbDocBody.ToString());
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
// Ignore
this error as this is caused due to termination of the Response Stream.
}
}
The Exported Word document looks as follows.
The Exported Word document looks as follows.
That’s it we have
exported the content of a DataTable into a Word Document, we can use this as a
generic function in projects and call it whenever we want to convert the data
in a DataTable to a Word document.
