Solved

How can I specify sheet name in SaveParser module

Posted on 2011-03-16
3
328 Views
Last Modified: 2012-05-11
Hi,

I am using Spreadsheet Save Parser module as below --

use Spreadsheet::ParseExcel::SaveParser;
 my $wr_parser  = Spreadsheet::ParseExcel::SaveParser->new();
 my $wr_workbook = $wr_parser->Parse("Test.xls");
  my $wr_worksheet = $wr_workbook->{Worksheet}[0];

Here I am specifying the first sheet to be updated as [0].

Can I specify the sheetname here instead of [0] $wr_workbook->{Worksheet}[0];
?

Alternatively, is there a way that given a sheetname, I can find its sheet no and then use it as above.

 
0
Comment
Question by:sunny82
  • 2
3 Comments
 

Author Comment

by:sunny82
ID: 35150479
The first question should be read as --

Can I specify the sheetname here instead of [0] in $wr_workbook->{Worksheet}[0];
?
0
 
LVL 26

Accepted Solution

by:
wilcoxon earned 500 total points
ID: 35150621
Sure.  You only have to change the way you are selecting the worksheet.
use Spreadsheet::ParseExcel::SaveParser;
my $wr_parser  = Spreadsheet::ParseExcel::SaveParser->new();
my $wr_workbook = $wr_parser->Parse("Test.xls");
my $wr_worksheet = $wr_workbook->worksheet('sheetname');

Open in new window

0
 

Author Comment

by:sunny82
ID: 35150632
ok great. Thanks :)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
There are many situations when we need to display the data in sorted order. For example: Student details by name or by rank or by total marks etc. If you are working on data driven based projects then you will use sorting techniques very frequently.…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

813 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

11 Experts available now in Live!

Get 1:1 Help Now