Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Accessing Worksheet name in excel

by Tortue (Scribe)
on Oct 09, 2005 at 19:24 UTC ( [id://498619]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $Book = $Excel->Workbooks->Open("Reten_template.xls") || die "can't
    + open file";
    
  2. or download this
    for (1..$Book->Worksheets->Count) {
        print "$_: <", $Book->Worksheets($_)->Name, ">\n";
    }
    
  3. or download this
    # open Excel file
    use File::Spec;
    my $file = File::Spec->rel2abs("Reten_template.xls");
    my $Book = $Excel->Workbooks->Open($file) or die "can't open $file: $!
    +\n";
    
  4. or download this
    my $Sheet = $Book->Worksheets('JUN05');
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://498619]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2024-04-20 01:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found