in reply to parsing excel with 5 levels of indentations
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
|
|---|