Re: Force Download to a .xls file


Perl: the Markov chain saw
	PerlMonks

Re: Force Download to a .xls file

by edan (Curate)

on Jan 04, 2005 at 12:15 UTC ( [id://419216]=note: print w/replies, xml )

Need Help??

in reply to Force Download to a .xls file

I use the following incantation, with success:

print $cgi->header(
  '-type' => "application/octet-stream; name=$file",
  '-Content-Disposition' => "attachment; filename=$file",
  '-Content-Transfer-Encoding' => "binary");
[download]

Note that $file is the basename, with no path - maybe that's all that's messing you up. In your case, it should just be "$xlsfile" I think.

--
edan

Comment on Re: Force Download to a .xls file Download Code

Replies are listed 'Best First'.

Re^2: Force Download to a .xls file
by existem (Sexton) on Feb 16, 2005 at 12:39 UTC

Just as a little side not to all this, i've finally managed to get it to work using this notation.

print "Content-type: application/vnd.ms-excel\n";
print "Content-Disposition: attachment; filename=$filename\n";
print "\n";

open    TMP, "$directory/$filename" or die "Error message here: $!\n";
binmode TMP;
binmode STDOUT;

print <TMP>;
[download]

Please note that the first bit just uses the basename of the file, so without the whole directory path. Whereas the second bit uses the $directory path so it's absolute on the file system. This little thing had me stumped for a while there, so thought i'd share incase others have the same problem.

Best of luck,
Tom

[reply]
[d/l]

In Section Seekers of Perl Wisdom