Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

How can I specify sheet name in SaveParser module

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
sunny82
Asked:
sunny82
  • 2
1 Solution
 
sunny82Author Commented:
The first question should be read as --

Can I specify the sheetname here instead of [0] in $wr_workbook->{Worksheet}[0];
?
0
 
wilcoxonCommented:
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
 
sunny82Author Commented:
ok great. Thanks :)
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now