Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Accessing Worksheet name in excel

by Tortue (Scribe)
on Oct 09, 2005 at 19:24 UTC ( #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? | Other CB clients
Other Users?
Others examining the Monastery: (2)
As of 2022-10-03 18:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My preferred way to holiday/vacation is:











    Results (15 votes). Check out past polls.

    Notices?