Export Html table to Excel Sheet. 1

[jagi]

Hi all,

Can anyone give me some links that can help me understand how to export HTML table to Excel Wroksheet?
Actually I have an option for the user to save the page with table and I would like to save it as an excel file when the user clicks on 'save'. Can anyone tell me how I can achieve this?

Thanks in advance.

 

[steven290]

using asp you can try place this at the top of the page

<%Response.ContentType = "application/vnd.ms-excel"%>

 

[Vragabond]

This is not an html question, since html cannot do anything of the sort. As steven290 said, you could use a server-side language to stream the contents into excel sheet. If you have no server side language available, your best bet is to use save as... and hope there's something there Excel can use.

 

[BillyRayPreachersSon]

A quick search of the posts shows this similar question in the JavaScript forum:

http://www.tek-tips.com/viewthread.cfm?qid=767875

with this handy URL:

http://www.greggriffiths.org/webdev/both/excel/

showing how to do just what you're after.

Hope this helps,
Dan




The answers you get are only as good as the information you give!