Export literal containing a table, to excel

Question

User-379429695 posted

I have a function, which exports a gridview to excel.

I have had to change my gridview, to an html table for various reasons.

my table is generated with a Literal, as such:

 

Literal.Text = "<table>"

     For each item in my dataset

             Literal.Text &= "<tr>"

             Literal.Text &= "<td>Some data here</td>"

             Literal.Text &= "<td>More here</td>"

             Literal.Text &= "</tr>"

     Next

Literal.Text &= "</table>"

I want to export this table to excel, and am not sure how exactly to reference each row (or) column (or) cell

My current thought is something like:

     For each row as DataRow in Literal.Text

              row.ExportThisRowToExcel

     Next

 

 

ideas?  =]