How to Export dynamically generated HTML table to Excel in VB.NET when using Master Page

See more:

VB

Hello Experts,

I am creating an Web application contains lot of reports to be generated. I am dynamically creating a "table" and adding "tr" and "td" based on the records from Database and appending it to String Builder and Finally assigning the string to InnerHTML of Div Tag.

I want to provide Exporting the Table to Excel for user and I am able to export the contents including CSS Style using the below code when it is an individual page. But the below code is not working when I go for Content Page(Having Master Page).

Response.Clear()
Response.ClearContent()
Response.ClearHeaders()
Response.Charset = ""
GenerateEvalReport() ' Generating the Table here and assigning to DIV.InnerHTML
Response.AddHeader("content-disposition", "EvalReport.xls")
Response.ContentType = "application/vnd.ms-excel"
' Response.ContentType = "application/ms-excel" -- Tried this also. Not Working

Dim objRow As New HtmlTableRow
Dim objCell As New HtmlTableCell
objCell.Controls.Add(tblBody) ' 'tblBody'- Id of my Dynamic Table
objRow.Cells.Add(objCell)
table1.Rows.Add(objRow) ' Have one more Table as 'table1'
table1.RenderControl(oHTMLTextWrite)
Response.Write(oStringWriter.ToString())
Response.Flush()
Response.End()

I am getting two different Errors(since I have used the same code in 2 pages) when using Response.Write(oStringWriter.ToString())
1. Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed
2. Unable to evaluate Expression. Thread Aborted.

Can you please point me where I made mistake.

Thanks a lot.