in reply to rowspan vals in Excel SS are not interpreted by ParseExcel::Simple

Spreadsheet::ParseExcel::Worksheet has a get_merged_areas() method

#!perl use strict; use Spreadsheet::ParseExcel; my $parser = Spreadsheet::ParseExcel->new(); my $workbook = $parser->parse('merge.xls'); for my $worksheet ( $workbook->worksheets() ) { my $range = $worksheet->get_merged_areas(); for (@$range){ print " start row : $_->[0] start col : $_->[1] end row : $_->[2] end col : $_->[3] \n\n"; } }
poj

Replies are listed 'Best First'.
Re^2: rowspan vals in Excel SS are not interpreted by ParseExcel::Simple
by misterperl (Friar) on Feb 08, 2017 at 20:58 UTC
    Thanks guys- I'll take a look at worksheets and merge/center.. It may solve the problem... Voted you all ++ I greatly appreciate the time you took to reply !