Spreadsheet::WriteExcel module

[Ra...@ubsw.com]

Hi John & All,

        I have been generating Excel reports for our higher management.

       1) Now iam trying to run them a website run on Apache:ASP. Though using the same PERL5LIB path i can generate them on commandline but it is giving me the errors as below when trying to run them on the website. I have been able to run them before i added the LibXSLT path 

        Looking at your documentation i have tried to add the lines for temporary folder but still is erroring out
 
my $workbook  = Spreadsheet::WriteExcel->new("/tmp/$$.xls");
my $workbook->set_tempdir('/tmp'); or my $workbook->set_tempdir(".");
my $worksheet = $workbook->addworksheet("Hello");

setenv LD_LIBRARY_PATH '/Net/stmdvocs/sbcexp/devl/SunOS/sparc-5.6/run/pd/libxml2/2.4.20/lib:/Net/stmdvocs/sbcexp/devl/SunOS/sparc-5.6/run//pd/libxslt/1.0.20/lib' (Using LibXSLT parser for the XML parsing)

setenv PERL5LIB '/Net/stmdvocs/sbcexp/devl/SunOS/sparc-5.6/run/pd/cpan/5.6.1-eval/lib:/sbcimp/run/pd/cpan/5.6.1-2002.06/lib:/sbcimp/run/pd/cpan/5.6.1-2002.03/lib/Spreadsheet/WriteExcel:/sbcimp/run/pd/cpan/5.6.1-2002.03/lib/Date'

#########################################################################################################################Can't locate File/Temp.pm in @INC (@INC contains: /home/nalamara/myapache/htdocs/asp/eg//. /sbcimp/run/pd/apache_modules/1.3.19/mod_perl/1.25+perl-5.005_03/lib/sun4-solaris /sbcimp/run/pd/apache_modules/1.3.19/mod_perl/1.25+perl-5.005_03/lib /Net/stmdvocs/sbcexp/devl/SunOS/sparc-5.6/run/pd/cpan/5.6.1-eval/lib /sbcimp/run/pd/cpan/5.6.1-2002.06/lib /sbcimp/run/pd/cpan/5.6.1-2002.03/lib/Spreadsheet/WriteExcel
#########################################################################################################################

2) Though i use dates on Excel reports generated in this manner i have not been able to get the day of the week or day no of the week to represent  for OCT 17 2002 as thurday - can this be done directly or even getting a day number would be fine.


       Please let me know if iam missing anything or syntatically incorrect.

Regards

Raghu


-----Original Message-----
From: John McNamara [mailto:jmcnamara@cpan.org]
Sent: Monday, August 12, 2002 7:03 PM
To: Nalamada, Raghu
Subject: RE: Spreadsheet::WriteExcel module


At 17:20 12/08/02 -0400, you wrote:
>         Yes i had used imagemagick module to convert a .png image to 
> ..bmp (in unix) . I had the replaced republic.bmp with the one i had 
> converted in demo.pl from the samples of your module.
>
>          It seems to erroring out as saying it is not a 24bit .bmp , 
> Could you please give any pointers how this can be resolved as iam 
> running out of options (is there any way to create a 24 bit bitmap using 
> imagemagick module).
>

Hi Raghu,

Could you send me the bitmap file and let me know how you converted it.

I'll look into it.

John.
--


Visit our website at http://www.ubswarburg.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  The sender therefore 
does not accept liability for any errors or omissions in the contents 
of this message which arise as a result of e-mail transmission.  If 
verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities or 
related financial instruments.


---------------------------------------------------------------------
To unsubscribe, e-mail: asp-unsubscribe@perl.apache.org
For additional commands, e-mail: asp-help@perl.apache.org

Re: Spreadsheet::WriteExcel module

[Josh Chamas <jo...@chamas.com>]

Raghu.Nalamada@ubsw.com wrote:
> Hi John & All,
> 
>         I have been generating Excel reports for our higher management.
> 
>        1) Now iam trying to run them a website run on Apache:ASP. Though using the same PERL5LIB path i can generate them on commandline but it is giving me the errors as below when trying to run them on the website. I have been able to run them before i added the LibXSLT path 
> 
>         Looking at your documentation i have tried to add the lines for temporary folder but still is erroring out
>  

 From the error message, I'd say you need to install File::Temp into
your PERL5LIB area.

--Josh
________________________________________________________________
Josh Chamas, Founder                   phone:925-552-0128
Chamas Enterprises Inc.                http://www.chamas.com
NodeWorks Link Checking                http://www.nodeworks.com


---------------------------------------------------------------------
To unsubscribe, e-mail: asp-unsubscribe@perl.apache.org
For additional commands, e-mail: asp-help@perl.apache.org