Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^3: parsing excel with 5 levels of indentations

by Happy-the-monk (Abbot)
on Oct 03, 2013 at 09:29 UTC ( #1056739=note: print w/ replies, xml ) Need Help??


in reply to Re^2: parsing excel with 5 levels of indentations
in thread parsing excel with 5 levels of indentations

my $cell = $worksheet->get_cell( $row, $col );

...

and here i need to put indent somewhere somehow

I haven't tried any of this, but continuing with the documentation of Spreadsheet::ParseExcel::Cell you should be able to test what my $format = $cell->get_format(); print $format->{Indent}, "\n"; is returning and build on that information.

Cheers, Sören

Créateur des bugs mobiles - let loose once, run everywhere.
(hooked on the Perl Programming language)


Comment on Re^3: parsing excel with 5 levels of indentations
Select or Download Code
Re^4: parsing excel with 5 levels of indentations
by leha (Novice) on Oct 03, 2013 at 11:09 UTC
    yes, McNamara gave me the same solution
    and it works
    thanks

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1056739]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2015-07-03 02:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (47 votes), past polls