Download html table content and save to excel

**Guvera** · Sep 29th, 2009, 03:27 PM

Hi,

<table id="myTable" border="1">
<tr> <b><td>Name </td> <td>Age</td></b></tr>
<tr> <td>Shivani </td> <td>25</td> </tr>
<tr> <td>Naren </td> <td>28</td> </tr>
<tr> <td>Logs</td> <td>57</td> </tr>
<tr> <td>Kas</td> <td>54</td> </tr>
<tr> <td>Sent </td> <td>26</td> </tr>
<tr> <td>Bruce </td> <td>7</td> </tr>
</table>

The above table is in my aspx page. One button name is download. Once i click the download button it will be download and write and save into excel file?? Is it possible??

Hope yours reply. Please make soon reply me. Its very urgent.

Thanks

**VBCrazyCoder** · Sep 29th, 2009, 03:48 PM

I haven't seen an html table to excel, but if you are loading the table from a dataset you can do that:

http://www.developer.com/net/asp/art...a-to-Excel.htm

Otherwise you may need to involve javascript to call a custom handler and pass it the html table values and the handler can do the work - just theory.

Anyone else do an html table to excel?

**Guvera** · Sep 29th, 2009, 03:56 PM

Hi,
Its not a data table. It is an aspx page that is <html><head><form>--
</form<</head></html>.table have an id. How can i import to excel. Not only data. Whatever it is in this table how write and save it to excel???

**gep13** · Sep 30th, 2009, 12:55 AM

Hey,

I think what VBCrazyCoder was getting at is, how is the table generated in the first place. Is it static, or is it populated from a database. If it is populated from a database, then the fact that the information in the table doesn't matter, you can just execute the same query again, and write directly into excel.

If it is static, then you are going to have to navigate the DOM in JavaScript, and then write it out to Excel. Here is an example of doing this:

http://www.devx.com/tips/Tip/14235

Also, please don't create multiple threads that are asking the same question:

http://www.vbforums.com/showthread.php?t=585881

One topic, one thread.

Gary

**Guvera** · Sep 30th, 2009, 02:36 AM

Hi gep,

Thanks for your reply. I am not using database for this one. I have an aspx page. In this page inside of <HTML></HTML> i put table and give id. Its k if possible to save as text file for this options???

Thanks

**gep13** · Sep 30th, 2009, 03:22 AM

Hey,

Sure it is, but are you wanting to do this on the server, or on the client?

Gary

**Guvera** · Sep 30th, 2009, 03:28 AM

Hi gep,

Thanks for your reply dude. I want both. I dont have an idea that what problem will come in client side and server side. So i need both client and server.

**gep13** · Sep 30th, 2009, 04:01 AM

Hey,

I am not sure that I follow what I was asking.

Are you trying to parse the table on the client using JavaScript?

Or, are you trying to parse the table on the server side using either C# or VB.Net. I am assuming that you are going to do this on the server, since you need to do a Response.Write of the file, but I am just wanting to clarify what you are doing, and whether you understand it.

Gary

**Guvera** · Sep 30th, 2009, 04:07 AM

Hi gep,

I need this one in client side using script. Because i have a table id. So its easy to implement in client side better than server. Could you plz give a solution to me??

**gep13** · Sep 30th, 2009, 04:30 AM

Hey,

You can easily navigate through the table by inspecting the DOM:

http://www.howtocreate.co.uk/tutoria...ript/dombasics

Gary

Thread: Download html table content and save to excel

Thread Tools

Display

Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Re: Download html table content and save to excel

Posting Permissions