Forum Moderators: coopster & phranque

Message Too Old, No Replies

downloading data in excel

excel and perl

         

shaan1980

2:01 pm on Jul 14, 2004 (gmt 0)

10+ Year Member



I want to select data from my database and plug those values into and excel file and allow the user to download this file.
I looked at the Spreadsheet::WriteExcel; module
but is there something that doesn't require an installation.
also
at the heading of my file i have
print "Content-type: text/html\n\n";
does this have any effect on the packages.
I am confused cause If i say use strict;
my file crashes
help keep it simple please

kaled

3:26 pm on Jul 14, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The Content-type: line creates (part of) the http header. This header is terminated by a blank line. Since \n is translated into a linefeed and there are two of them, we can deduce that this is the last line of the header.

"crashes" is not very specific. If you're getting an INTERNAL SERVER ERROR, it probably means the script fails to compile. strict requires, amongst other things, all global variables to be explicitly declared. Failure to do so will cause a compilation error.

I have no knowledge of Excel, etc. but I suspect that what you're trying to do requires a substantially greater knowledge of Perl than you possess. If you intend learning the language, you'll need perl on your PC. Visit activestate.com

Hope this helps.

Kaled.