Exporting from an HTML table to a Spreadsheet

[=?Utf-8?B?Q2FybGl0b3M=?=]

Hi there,

I have a asp.net page that dynamically constructs a table based on data
retrieved from a database. This is an excerpt of the code used:

' Create a row
Dim row As HtmlTableRow = New HtmlTableRow
' Create a column and add it to the row
Dim cell As HtmlTableCell = New HtmlTableCell
cell.InnerText = sValue
row.Cells.Add(c ell)
' ... other columns created and added...
tblSummaryTable .Rows.Add(row) ' tblSummaryTable already exists on page,
running at server
' ... loop to add more rows as needed...

Now I need to export this table to a spreadsheet when the user clicks a
button on the page.

I have tried a variety of routines, suggestions, etc. None of them have
worked. I only get an empty spreadsheet, sometimes with very wide column (I
don't know why).

Almost all examples I have seen involve the use of datasets/datagrids. For
reasons not relevant to the question, I cannot use datagrids for this.

The question is: Can an HTML table be exported or converted to a spreadsheet
directly (or through a routine, whatever)?

Many thanks,

--
Carlitos

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

This sample is for a GridView, but it should work for any servercontrol:

// you also need this to suppress "not inside Form tag" errors on
RenderControl
public override void VerifyRendering InServerForm(Co ntrol control)
{
// no-op, just override so base doesn't do anything
}
protected void lnkExport_Click (object sender, EventArgs e)
{

Response.Clear( );
Response.AddHea der("content-disposition",
"attachment;fil ename=OvertureR eport.xls");
Response.Charse t = "";
// If you want the option to open the Excel file without saving
than
// uncomment the line below
Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);
Response.Conten tType = "applicatio n/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite =
new HtmlTextWriter( stringWrite);
gvDomains.Rende rControl(htmlWr ite);
Response.Write( stringWrite.ToS tring());
Response.End();

}

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com
"Carlitos" wrote:

Hi there,

I have a asp.net page that dynamically constructs a table based on data
retrieved from a database. This is an excerpt of the code used:

' Create a row
Dim row As HtmlTableRow = New HtmlTableRow
' Create a column and add it to the row
Dim cell As HtmlTableCell = New HtmlTableCell
cell.InnerText = sValue
row.Cells.Add(c ell)
' ... other columns created and added...
tblSummaryTable .Rows.Add(row) ' tblSummaryTable already exists on page,
running at server
' ... loop to add more rows as needed...

Now I need to export this table to a spreadsheet when the user clicks a
button on the page.

I have tried a variety of routines, suggestions, etc. None of them have
worked. I only get an empty spreadsheet, sometimes with very wide column (I
don't know why).

Almost all examples I have seen involve the use of datasets/datagrids. For
reasons not relevant to the question, I cannot use datagrids for this.

The question is: Can an HTML table be exported or converted to a spreadsheet
directly (or through a routine, whatever)?

Many thanks,

--
Carlitos

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

Yes, you can use this free control to export your HTML to Excel, or you can
read about how the source code works and do it yourself:
http://SteveOrr.net/articles/ExportPanel.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
http://iPhonePlaza.net
"Carlitos" <Ca******@discu ssions.microsof t.comwrote in message
news:27******** *************** ***********@mic rosoft.com...

Hi there,

I have a asp.net page that dynamically constructs a table based on data
retrieved from a database. This is an excerpt of the code used:

' Create a row
Dim row As HtmlTableRow = New HtmlTableRow
' Create a column and add it to the row
Dim cell As HtmlTableCell = New HtmlTableCell
cell.InnerText = sValue
row.Cells.Add(c ell)
' ... other columns created and added...
tblSummaryTable .Rows.Add(row) ' tblSummaryTable already exists on page,
running at server
' ... loop to add more rows as needed...

Now I need to export this table to a spreadsheet when the user clicks a
button on the page.

I have tried a variety of routines, suggestions, etc. None of them have
worked. I only get an empty spreadsheet, sometimes with very wide column
(I
don't know why).

Almost all examples I have seen involve the use of datasets/datagrids.
For
reasons not relevant to the question, I cannot use datagrids for this.

The question is: Can an HTML table be exported or converted to a
spreadsheet
directly (or through a routine, whatever)?

Many thanks,

--
Carlitos

[gnewsgroup]

On Feb 4, 1:23*pm, "Steve C. Orr [MCSD, MVP, CSM, ASP Insider]"
<[e-mail] rote:

Yes, you can use this free control to export your HTML to Excel, or you can
read about how the source code works and do it yourself:http://SteveOrr.net/articles/ExportPanel.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsiderhttp://SteveOrr.nethtt p://iPhonePlaza.net

I have been using Steve's free ExportPanel to export web page to
Word. Really nice, and I strongly recommend. Thank Steve for sharing
for free.

[siccolo]

you can save a HTML table to a file with extension "xls" and then
redirect user (i.e users browser) to that page:
http://www.siccolo.com/temp/html_2_excel.gif