DelphiFAQ Home Search:
perl
    mysql (3)
    perl CGI (65)

 
Exchange Links
 
About this site

Links to us


Website Monitoring
Bookmark this
Add to del.icio.us Digg! Add to Reddit Add to Yahoo MyWeb Add to Windows Live Add to Google Bookmarks Share via Facebook

Perl script on web server sends Excel file to browser

 

comments200 comments. Current rating: 2 stars (199 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 14, other pages: [1] 2 3 4 11 12 13 14
2009-06-07, 22:55:14
anonymous from Canada  
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
2019-04-08, 15:42:07
anonymous from Russian Federation  
rating
[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]
2019-04-08, 16:23:34
anonymous from Russian Federation  
rating
[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]
2019-04-08, 17:03:13
anonymous from Russian Federation  
rating
2019-04-08, 17:19:46
anonymous from Russian Federation  
rating
[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]
2019-04-08, 17:25:39
anonymous from Russian Federation  
rating
2019-04-08, 17:33:35
anonymous from Russian Federation  
rating
2019-04-08, 17:35:26
anonymous from Russian Federation  
rating
2019-04-08, 19:14:41
anonymous from Russian Federation  
rating
[url= https://tadalafilgen..]tadalafil tablets 20 mg[/url]
2019-04-08, 19:33:15
anonymous from Russian Federation  
rating
2019-04-08, 19:41:36
anonymous from Russian Federation  
rating
2019-04-08, 20:30:36
anonymous from Russian Federation  
rating
[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]
2019-04-08, 21:47:35
anonymous from Russian Federation  
rating
2019-04-08, 22:13:47
anonymous from Russian Federation  
rating
[url= https://camsites.icu/]adult videos[/url]
2019-04-08, 23:42:25
anonymous from Russian Federation  
rating
You are on page 1 of 14, other pages: [1] 2 3 4 11 12 13 14

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as 		Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

 Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: