merrymonk has asked for the wisdom of the Perl Monks concerning the following question:

For a long time I have been getting an array of values from a spreadsheet using.
\@cell_array = $worksheet->range($excel_data_range)->{'value'};

and then going through the 2 dimensional array to read the value of each cell.
I now want to read tags and formulae that associated with each cell.
I guess that I need something instead of ‘value’ in the ->{} .
Can anyone tell me what this should be or even a location where all the options for range can be found.

Replies are listed 'Best First'.
Re: Reading Excel tags and formulae
by Ratazong (Monsignor) on Aug 13, 2015 at 09:54 UTC

    Dear merrymonk,

    I use FormulaR1C1 instead of value for formulae.

    HTH, Rata