in reply to parsing excel with 5 levels of indentations

Well, https://metacpan.org/module/Spreadsheet::ParseExcel::Format shows no  $format->{Indent}

https://metacpan.org/module/Spreadsheet::ParseExcel shows  $format->{Indent} but its not in the synopsis -- simply copy/pasting from SYNOPSIS won't make $format a defined variable

I can't tell from the documentation how to create a $format, but I know a trick, go to https://metacpan.org/release/Spreadsheet-ParseExcel and find https://metacpan.org/source/JMCNAMARA/Spreadsheet-ParseExcel-0.59/sample/chkInfo.pl

... $oWkS = $oBook->{Worksheet}[$iSheet]; ... $oWkC = $oWkS->{Cells}[$iR][$iC]; ... print 'Indent :', $oWkC->{Format}->{Indent}, "\n",

So you'd have to do something like that, good luck, I'm out

  • Comment on Re: parsing excel with 5 levels of indentations ( JMCNAMARA/Spreadsheet-ParseExcel-0.59/sample/chkInfo.pl )
  • Select or Download Code