Need help with code to download table to excel

lxrocks · May 14, 2007

Hi
I have always downloaded table data to excel using a perl_cgi. The perl
cgi will simpley print("Content-Type: application/vnd.ms-excel");
followed by the usual html table formatted data.

However if I try the same with javascript it does not seem to work.

ie document.write("Content-Type: application/vnd.ms-excel");
document.write("<html><table><thead>bla bla...</html>);

This never triggers the save file as/ or open with excel. It displays
the data in the browser but does not trigger an excel save.

What am I doing wrong?

Thanks

ASM · May 14, 2007

lxrocks a écrit :

Hi
I have always downloaded table data to excel using a perl_cgi. The perl
cgi will simpley print("Content-Type: application/vnd.ms-excel");
followed by the usual html table formatted data.

where does-it print that ?

However if I try the same with javascript it does not seem to work.

where do you try the following ?

ie document.write("Content-Type: application/vnd.ms-excel");
document.write("<html><table><thead>bla bla...</html>);

That would have to write an "html" file ( *.html )

This never triggers the save file as/ or open with excel. It displays
the data in the browser but does not trigger an excel save.

What am I doing wrong?

To do not produce an Excel file ( *.xls ) ?

My last play with this idea (Excel document) :
http://perso.orange.fr/stephane.moriaux/truc/html_to_xls_op.shtml

Perhaps with XML and JS-DOM ?

And read or re-read here in c.l.javascript the thread :
"FAQ Topic - How do I prompt a "Save As" dialog for an accepted mime type?"
<http://groups.google.com/group/comp...0349b96de6/75c7b581bb814f10?#75c7b581bb814f10>

lxrocks · May 14, 2007

ASM said:
lxrocks a écrit :

where does-it print that ?

where do you try the following ?

That would have to write an "html" file ( *.html )

To do not produce an Excel file ( *.xls ) ?

My last play with this idea (Excel document) :
http://perso.orange.fr/stephane.moriaux/truc/html_to_xls_op.shtml

Perhaps with XML and JS-DOM ?

And read or re-read here in c.l.javascript the thread :
"FAQ Topic - How do I prompt a "Save As" dialog for an accepted mime type?"
<http://groups.google.com/group/comp...0349b96de6/75c7b581bb814f10?#75c7b581bb814f10>

I realise now that there is a difference between client and server side
code when dealing with Mime. Thank you for the example it is most helpful.

Help with code	0	Jun 12, 2022
Only one table shows up with the information	2	Mar 29, 2023
How to mimic Excel download?	3	May 22, 2008
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript?	0	May 1, 2023
Need help with stripe payment	0	Oct 2, 2021
Collect Excel Data from Website	5	Apr 30, 2022
Help with my responsive home page	2	Dec 14, 2022
Need help fixing code	1	Mar 30, 2018

Need help with code to download table to excel

lxrocks

ASM

lxrocks

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads