mysql (3)
perl CGI (65)
Exchange Links
About this site
New related comments
Number of comments in the last 48 hours
Perl script on web server sends Excel file to browser
1 new comments
Perl script on web server sends Excel file to browser
159 comments. Current rating: 
(156 votes). Leave comments and/ or rate it.
Question:
I need to have my web site generate an Excel worksheet on the fly (a database export) and send it to the user's webbrowser. How can I do that?Answer:
The following assumes that you export a simple sheet containing strings and numbers, no formulas.In this case, you can generate a CSV file (comma separated values) and set the mime type to applicatioon/octet-stream.
If you perl script is called as /cgi-bin/exportcsv.pl then the downloaded file will by default be named
exportcsv.pl.xls (using alternative mime type application/vnd.ms-excel)
To suggest a specific file name (other than the script name, use the Content-Disposition header field. This field allows you to provide other information as well, e.g.
- creation-date
- modification-date
- read-date
- size
Note:
The size parameter indicates just an approximate size of the file in octets. It does not have to be the exact size. This information can be used by the client software (web browser) to pre-allocate space before attempting to store the file, or to determine whether enough space exists.
For the full syntax, see RFC 2183
 |  | |
# alternative 1: # sending a file simply as an Excel print "Content-type: application/vnd.ms-excel\n"; print "Content-Disposition: attachment;filename=users.csv\n\n"; # alternative 2: # sending a CSV file and suggesting 'users.csv' as the file name print "Content-type: application/octet-stream\n"; print "Content-Disposition: attachment;filename=users.csv\n\n"; # now dump the data # all values are enclosed by " in case the # strings contain a comma # this dumps 2 rows with 2 columns each print '"1","Test, first one"' . "\n"; print '"2","Test, last one"' . "\n"; | ||
 |  |
|
||||||||
Comments:
| You are on page 1 of 11, other pages: [1] 2 3 4 8 9 10 11 | ||
| ||
|
I'm calling a Perl Script from a Javascript (AJAX) which has to generate CSV on the fly... I tried using the above code. But its not working.
JavaScript Function function testCSV() { alert('Got the data'); new Ajax.Request(cgiPath+'testCSV.pl', { method: 'get', parameters: { action: 'createCSV', type: 'sample', ts: new Date().getTime() }, onComplete: function() { alert('Created CSV'); } }); } Perl Script use CGI; use JSON; $cgi = new CGI(); $action = $cgi->param('action'); if ($action eq 'createCSV') { createCSV(); } else { die 'Action not specified'; } sub createCSV { print 'Content-type: application/octet-stream\n'; print 'Content-Disposition: attachment;filename=users.csv\n\n'; print ''1','Test, first one'' . '\n'; print ''2','Test, last one'' . '\n'; } Please help | ||
| ||
|
[url=
 https://adultchatroo..site/]free adult chat[/url] [url= https://hotwebcamgir...site/]hot webcam girls[/url] [url= https://freeadultcam..top/]adult cam chat[/url] [url= https://freechatrooms.icu/]sex chat rooms[/url] [url= https://freelivesexc..t.icu/]sex chat free[/url] | ||
| ||
|
[url=
https://valtrex500mg.com/]buy generic valtrex online[/url] [url= https://tadalafil20t..com/]cheap tadalafil 20mg[/url] [url= https://celebrex100...m/]generic celebrex[/url] [url= https://cheapprednis../]purchass of prednisolone tablets[/url] [url= https://prednisone91..sone[/url] [url= https://buysildenafi..sildenafil 50mg[/url] [url= https://prednisonege..ic.com/]no prescription prednisone[/url] [url= https://buyamoxicill..moxicillin without a prescription[/url] [url= https://prednisolone..ednisolone online[/url] [url= https://doxycycline2.com/]buy doxycycline[/url] | ||
| ||
|
[url=
https://sextalk.site/]sex talk[/url] [url= https://videochatroo..ive/]video chat room[/url] [url= https://freewebcams.ml/]free adult cam to cam[/url] [url= https://freelivesexc..chat[/url] [url= https://maturewebcam..te/]webcam girl[/url] | ||
| ||
|
[url=
https://albuterol24.com/]buy albuterol online without prescription[/url] [url= https://valtrex500mg..com/]cheap valtrex online[/url] [url= https://femaleviagra..m/]levitra for women[/url] [url= https://buydoxycycli..n.com/]buy generic doxycycline[/url] [url= https://lasix0.com/]..asix[/url] [url= https://prednisone91..sone[/url] [url= https://cheapprednis..e.com/]buy prednisolone 5mg[/url] [url= https://buyacyclovir..]acyclovir buy online[/url] [url= https://stromectolon..com/]cheap stromectol[/url] [url= https://metformin100..]metformin 500mg[/url] | ||
| ||
|
[url=
https://buyrobaxinon..m/]robaxin buy[/url] [url= https://lasix0.com/]..asix[/url] [url= https://amoxicillin9..1.com/]buy amoxicilina 500 mg[/url] [url= https://buyacyclovir..n.com/]buy acyclovir[/url] [url= https://buylasixfuro..mide[/url] [url= https://metformin100..rmin[/url] [url= https://buydoxycycli..oxycycline buy[/url] [url= https://viagrasofton..om/]online viagra soft[/url] [url= https://albuterol24...m/]generic albuterol online[/url] [url= https://synthroid1.c..roid[/url] | ||
| ||
|
[url=
https://adultcams.fun/]adult chatroom[/url] [url= https://nudelive.fun/]live nude[/url] [url= https://videochatroo..icu/]adult video chat[/url] [url= https://webcamamateu..te/]webcam amateur[/url] [url= https://sextalk.site/]wicked cam[/url] | ||
| ||
|
[url=
https://zoloft75.com..loft[/url] [url= https://albuterol24...]albuterol ventolin[/url] [url= https://celebrex100.../]celebrex medication[/url] [url= https://metformin100..]metformin 500 mg[/url] [url= https://buysildenafi..com/]where to buy sildenafil online[/url] | ||
| ||
|
[url=
https://tadalafilgen..]tadalafil tablets 20 mg[/url] | ||
| ||
|
[url=
https://freeadultweb..site/]free adult webcam chat rooms[/url] [url= https://webcamamateu..un/]webcam amateur[/url] [url= https://hotwebcamgir..site/]cfnm show[/url] [url= https://slutcams.fun/]porn cams[/url] [url= https://adultwebcams.icu/]nude webcams[/url] [url= https://webcamamateu..u/]amateur webcam sex[/url] [url= https://girlcam.stream/]girl cam[/url] [url= https://adultchat.fun/]adult chat[/url] [url= https://slutcams.icu/]porn cams[/url] [url= https://sexwebcam.st..chat[/url] | ||
| ||
|
[url=
https://lisinopril0...pril[/url] [url= https://doxycycline2..com/]where to get doxycycline[/url] [url= https://zithromax500..]zithromax 500[/url] [url= https://genericciali..alis[/url] [url= https://buylasixfuro..furosemide 40 mg[/url] | ||
| ||
|
[url=
https://lisinoprilze..pril[/url] [url= https://viagrasofton..om/]viagra soft[/url] [url= https://tadalafil20t...com/]cost of tadalafil[/url] [url= https://buypropeciaf..e.com/]buy propecia finasteride[/url] [url= https://amoxicillin9..moxicillin brand name[/url] [url= https://cheapprednis..ednisolone uk[/url] [url= https://tadalafilgen..m/]generic cialis tadalafil[/url] [url= https://lisinopril0...lisinopril 10mg[/url] [url= https://valtrex500mg..m/]valtrex cheap[/url] [url= https://lasix0.com/]buy lasix online no prescription[/url] | ||
| ||
|
[url=
https://prednisolone..ednisolone online[/url] [url= https://femaleviagra..om/]viagra for females[/url] [url= https://buylasixfuro..e.com/]buy lasix[/url] [url= https://amoxicillin9..moxicillin 500[/url] [url= https://ventolinhfai..olin[/url] [url= https://tadalafilgen..]tadalafil 20 mg[/url] [url= https://valtrex500mg..m/]valtrex for sale[/url] [url= https://viagrasofton..e.com/]buy viagra soft[/url] [url= https://buypropeciaf..e.com/]buy propecia[/url] [url= https://acyclovir1.c..m/]zovirax pills[/url] | ||
| ||
|
[url=
https://camsites.icu/]adult videos[/url] | ||
| ||
|
[url=
https://livecamgirls.icu/]web cam girls[/url] [url= https://sexwebcam.st..m/]amateur webcam sex[/url] [url= https://chatporn.site/]private webcam[/url] [url= https://interactivep..nteractive porn[/url] [url= https://slutcams.site/]mature webcams[/url] [url= https://liveporncams.fun/]live porn cams[/url] [url= https://camsex.cf/]cam sex[/url] [url= https://livenaked.top/]nude live[/url] [url= https://freelivesex.site/]free live sex[/url] [url= https://webcamteens...cu/]webcam teens[/url] | ||
| You are on page 1 of 11, other pages: [1] 2 3 4 8 9 10 11 |
