https://metacpan.org/pod/Spreadsheet::ParseExcel#worksheets()
parser
- new():生成一个新的parser
my $parser = Spreadsheet::ParseExcel->new(); - parse($filename, $formatter) :吃进一个excel档,并给出handler。
my $workbook = $parser->parse(‘Book1.xls’);
workbook
- worksheets():得到workbook中所有sheet的handler
for my $worksheet ( $workbook->worksheets() ) - worksheet():根据index或者name得到一个特定worksheet的handler
$worksheet = $workbook->worksheet(‘Sheet1’);
$worksheet = $workbook->worksheet(0); - worksheet_count():得到workboot中worksheet的数量
my $worksheet_count = $workbook->worksheet_count(); - get_filename():得到excel workbook的名字
my $filename = $workbook->get_filename();