use Spreadsheet::WriteExcel

Posted on 2005-05-04
Last Modified: 2008-03-10
I have a perl scripts with this statement

use Spreadsheet::WriteExcel;

1. Where i can see the functions, properties available for the Excel object used in the Perl?

e.g.     $workbook  = Spreadsheet::WriteExcel->new("-");
    my $format = $workbook->addformat();

Where i can see other functions and properties available for Spreadsheet objects?
Question by:StanleyLMW

    Author Comment

    there is no perl expert?
    LVL 20

    Accepted Solution

    I'm sure a number of the Perl experts have viewed your question by now, but none have a ready answer. In reading your question again, I'm not even sure I know what you're asking. The Spreadsheet::WriteExcel module is still rather limited in its capabilities, from what I understand. I've never used it myself and all I could do is direct you to the built-in documentation:

    That will give you a list of the methods available and searching around for other related modules may begin to yield answers to your question.

    EE Page Editor for Perl

    Author Comment


    My question is very simple.

    Just want to have a reference guide which tells me what are the objects i can use in Perl. And for each object, i have a guide to see their functions, properties i can use and how to use them.

    Author Comment


    i found what i need from CPAN. thanks!

    Author Comment


    how come i cannot accept your answer?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Many time we need to work with multiple files all together. If its windows system then we can use some GUI based editor to accomplish our task. But what if you are on putty or have only CLI(Command Line Interface) as an option to  edit your files. I…
    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…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now