Export DataGrid to Excel problem

Guest · May 27, 2005

When i export DataGrid to Excel all the HTML contents are also exporting to
excel. i am using stylesheets in the ASPX Page and i am getting an alert
message that stylesheets are missing. i need to export only the contents of
the Datagrid to excel. i don't need all other stuff which is present on the
page. is there any way to achieve it.

Thanks in Advance

Guest · May 27, 2005

try this...

Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Dim oStringWriter As New System.IO.StringWriter
Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)

oHtmlTextWriter.Write("<html><head>")

oHtmlTextWriter.Write("<style>")
oHtmlTextWriter.Write(".dataGridHeader{font-weight: bold;font-size:
8pt;color: black;font-family: Verdana;background-color: #ddddee;text-align:
left;}")
oHtmlTextWriter.Write(".dataGridItemStyle{font-size: 8pt;color:
black;font-family: Verdana;text-align: left;}")

oHtmlTextWriter.Write("</style>")
oHtmlTextWriter.Write("</head><body>")

oHtmlTextWriter.WriteBeginTag("form runat=server ")
oHtmlTextWriter.WriteAttribute("target", "_blank")
oHtmlTextWriter.Write(">")
dgReport.RenderControl(oHtmlTextWriter)

oHtmlTextWriter.Write("</form></body></html>")
Response.Write(oStringWriter.ToString())
Response.End()

--
http://pathidotnet.blogspot.com
=====
vInAypAtHi
o__
---_,>/'_------
(_) \(_)

Steve C. Orr [MVP, MCSD] · May 29, 2005

Well that depends on what technique you are using to export the datagrid.
There are a variety of ways to export ASP.NET content to Excel.
Most of the techniques are described in detail here:
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/articles/ExcelExport.aspx

These examples remove all the extra HTML "stuff" you're talking about.

Guest · Jun 1, 2005

Thank you vinay and Steve. My problem is solved.

Steve C. Orr said:
Well that depends on what technique you are using to export the datagrid.
There are a variety of ways to export ASP.NET content to Excel.
Most of the techniques are described in detail here:
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/articles/ExcelExport.aspx

These examples remove all the extra HTML "stuff" you're talking about.

Export DataGrid to Excel	2	May 23, 2005
Outlook Converter Tool to Export OST/PST in Single Time	5	Oct 9, 2024
I want to Display Excel As HTML In js	2	Feb 24, 2023
Image shifts to the right when export the page to pdf	4	May 5, 2023
API to excel dont show data	0	Feb 15, 2024
I want to make such a page in which i can put my excel file.	1	Jun 23, 2023
Html / Aspx Export to Excel	0	Sep 27, 2006
export to excel	1	Sep 29, 2006

Export DataGrid to Excel problem

Guest

Guest

Steve C. Orr [MVP, MCSD]

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads