Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > excel export

Reply
Thread Tools

excel export

 
 
naren
Guest
Posts: n/a
 
      02-10-2004
Hi,
I am trying to export some data into excel through cgi script,
I am using a standard example given in Spreadsheet::WriteExcel
module,
here is the code:

--------------------------------------------------------
#!/apps/bin/perl -w

use strict;
use Spreadsheet::WriteExcel;

# Set the filename and send the content type
my $filename ="cgitest.xls";

print "Content-type: application/vnd.ms-excel\n";
# The Content-Disposition will generate a prompt to save the file. If
you want
# to stream the file to the browser, comment out the following line.
print "Content-Disposition: attachment; filename=$filename\n";
print "\n";

# Create a new workbook and add a worksheet. The special Perl
filehandle - will
# redirect the output to STDOUT
#
my $workbook = Spreadsheet::WriteExcel->new("-");
my $worksheet = $workbook->add_worksheet();

# Set the column width for column 1
$worksheet->set_column(0, 0, 20);

# Create a format
my $format = $workbook->add_format();
$format->set_bold();
$format->set_size(15);
$format->set_color('blue');

# Write to the workbook
$worksheet->write(0, 0, "Hi Excel!", $format);
----------------------------------------------------

But the script is failing at $workbook->add_worksheet(),
here is the error message:
---
Can't locate object method "add_worksheet" via package
"Spreadsheet::WriteExcel" (perhaps you forgot to load
"Spreadsheet::WriteExcel"?) at /cgi-excel.pl line 19.
---

I have checked the path, it should be getting the
Spreadsheet::WriteExcel module, this error may be missleading??
This code was working FINE till last week, but it has broken now;
recently we have updated some of our other perl modules like IO, MIME
etc,
if Spreadsheet::WriteExcel module is using some of those libraries
internally, is there a chance that it will be affected?? I assume it
is not.

Can any body any idea??

thanks,
Naren.
 
Reply With Quote
 
 
 
 
Simon Taylor
Guest
Posts: n/a
 
      02-11-2004
Hello Naren,

> I am trying to export some data into excel through cgi script,
> I am using a standard example given in Spreadsheet::WriteExcel
> module,
> here is the code:
>
> --------------------------------------------------------
> #!/apps/bin/perl -w
>
> use strict;
> use Spreadsheet::WriteExcel;


[snip]

> my $workbook = Spreadsheet::WriteExcel->new("-");
> my $worksheet = $workbook->add_worksheet();


This should be:

my $worksheet = $workbook->addworksheet();


> my $format = $workbook->add_format();


and that should be:

my $format = $workbook->addformat();

Happy hacking.

Simon Taylor
--
Unisolve Pty Ltd - Melbourne, Australia

 
Reply With Quote
 
 
 
 
John McNamara
Guest
Posts: n/a
 
      02-11-2004
naren wrote:

> But the script is failing at $workbook->add_worksheet(),
> here is the error message:
> ---
> Can't locate object method "add_worksheet" via package
> "Spreadsheet::WriteExcel" (perhaps you forgot to load
> "Spreadsheet::WriteExcel"?) at /cgi-excel.pl line 19.


Hi,

The method names add_worksheet() and add_format() were added in
version 0.41 of the Spreadsheet::WriteExcel. From the changelog:

0.41 April 24 2003 - Minor

! Renamed addworksheet() and addformat() to add_worksheet()
and add_format() for consistency with other method names.
Older names are supported but deprecated.


If you have an older version use addworksheet() and addformat()
instead.

John.
--
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to Excel (Default File Type - Excel) =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?= ASP .Net 15 05-21-2009 12:01 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Export to excel in asp.net using excel template Grey ASP .Net 4 10-17-2007 08:08 AM
using Microsoft Excel image for Export to Excel button =?Utf-8?B?U3JpZGhhcg==?= ASP .Net 0 12-09-2005 08:58 PM
Invalid export DLL or export format =?Utf-8?B?RGF2aWQgVmFsbGU=?= ASP .Net 0 10-29-2003 11:46 AM



Advertisments