Solved

Trouble in installing Parse::DecDescent module.

Posted on 2006-11-15
3
654 Views
Last Modified: 2012-06-27
Dear Expert,

In  order to use Spreadsheet-WriteExcel, I need to install Parse::DecDescent module. In its readme file, it tells how to install:
---------------------------------------------------------------------------------------
INSTALLATION

    It's all pure Perl, so just put the .pm files in their appropriate
    local Perl subdirectories.
---------------------------------------------------------------------------------------

What is this local Perl subdirectories? I just put DecDescent.pm file in any one of these three directories
\usr\lib\perl5\site_perl\5.8\Spreadsheet\
\usr\lib\perl5\site_perl\5.8\Spreadsheet\WriteExcel
usr\lib\perl5\vendor_perl\5.8\
 it doesn't work for me.

I wrote a test.pl:
#!/usr/bin/perl -w

#use strict;
use Spreadsheet::WriteExcel;

 # Create a new Excel workbook
    my $workbook = Spreadsheet::WriteExcel->new("perl.xls");

    # Add a worksheet
    $worksheet = $workbook->add_worksheet();

    #  Add and define a format
    $format = $workbook->add_format(); # Add a format
    $format->set_bold();
    $format->set_color('red');
    $format->set_align('center');

    # Write a formatted and unformatted string, row and column notation.
    $col = $row = 0;
    $worksheet->write($row, $col, "Hi Excel!", $format);
    $worksheet->write(1,    $col, "Hi Excel!");

    # Write a number and a formula using A1 notation
    $worksheet->write('A3', 1.2345);
    $worksheet->write(3,    $col, "Excel!");
    $worksheet->write('A4', '=SIN(PI()/4)');

When I run test.pl, it always complaints:
The Parse::RecDescent module must be installed in order to write Excel formula.
So it seems that it can not find DecDescent.pm, where should DecDescent.pm be put?

Thanks.
Hanqian  
0
Comment
Question by:Hanqian
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
Adam314 earned 50 total points
ID: 17948752
\usr\lib\perl5\site_perl\5.8\Parse\RecDescent.pm

0
 

Author Comment

by:Hanqian
ID: 17948875
It works now. Thanks to Adam314.

Hanqian
0
 
LVL 39

Expert Comment

by:Adam314
ID: 17948930
typo: \usr\lib\perl5\site_perl\5.8\Parse\DecDescent.pm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now