export to excel

[ocap]

I would like write to Excel file the result of a query on a db table
with a CGI Perl. My CGI allows output to HTML table by Template.pm
module; can you help me?
With Java it's very easy

response.setContentType("application/vnd.ms-excel")

But with Perl? In the same script I want allow output in html and
output in excel file (user choices). Can I do it using Template.pm
module?

Hi
ocap

 

[Leon]

I would like write to Excel file the result of a query on a db table
with a CGI Perl. My CGI allows output to HTML table by Template.pm
module; can you help me?
With Java it's very easy

response.setContentType("application/vnd.ms-excel")

But with Perl? In the same script I want allow output in html and
output in excel file (user choices). Can I do it using Template.pm
module?

Hi
ocap

Not sure about the Template.pm as I haven't used it, but you could just
write the results from your query out to a .csv file. This would be Excel
friendly and very easy to import.

 

[James Willmore]

Not sure about the Template.pm as I haven't used it, but you could just
write the results from your query out to a .csv file. This would be Excel
friendly and very easy to import.

Or, in Perl, you could just send the proper header ....

#"quick and dirty" in the main script using the template
print "Content-type: application/vnd.ms-excel\n\n";

#using the CGI module in the main script using the template
print header(-type => 'application/vnd.ms-excel');
#-or-
print $query->header(-type => 'application/vnd.ms-excel');

HTH

Jim

 

[James Willmore]

I would like write to Excel file the result of a query on a db table
with a CGI Perl. My CGI allows output to HTML table by Template.pm
module; can you help me?
With Java it's very easy

response.setContentType("application/vnd.ms-excel")

But with Perl? In the same script I want allow output in html and
output in excel file (user choices). Can I do it using Template.pm
module?

Or, in Perl, you could just send the proper header ....

#"quick and dirty" in the main script using the template
print "Content-type: application/vnd.ms-excel\n\n";

#using the CGI module in the main script using the template
print header(-type => 'application/vnd.ms-excel');
#-or-
print $query->header(-type => 'application/vnd.ms-excel');

HTH

Jim