"The documented interface" - can tell me where this is? The metaCPAN page is minimal.
Also, if the cell contains the text "0.153", why would "value" and "unformatted" differ by 0.003?
Ty | [reply] |
if the cell contains the text "0.153", why would "value" and "unformatted" differ by 0.003?
Have you ever used Excel? The value in the cell and what is displayed in the cell do not have to match. If you have the contents 0.153 and use cell formatting to display in two-decimal fixed-point as 0.15, the difference between the underlying value and the displayed value will be 0.003 -- that's the way Excel works. If you were to run the same experiment, but set the cell format to "blah" 0.00 "blah", you would find that the real value was 0.153, but the displayed value was the string blah 0.15 blah. If you want the actual data from the cell, use the unformatted method; if you want to know how Excel last rendered that cell, use the value method; if you want to run the risk of the underlying implementation of Spreadsheet::XLSX changing on you, use the hash key Val to currently be equivalent to the unformatted method or the underlying Excel data, and use the hash key _Value to currently be equivalent to running the value method (with no guarantee that in future versions those same hash keys will exist, or that it will even be a hash-based object). Using the underlying hash of an object (if it's currently implemented as a hash) is a bad idea, unless the official documentation tells you to access the hash elements directly -- and even then, using the defined accessor methods is a better idea (unless the author doesn't provide accessors).
"The documented interface" - can tell me where this is? The metaCPAN page is minimal.
In the docs for Spreadsheet::XLSX, it says,
This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format. It supports styles and many of Excel's quirks, but not all. It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet, and Cell.
... which strongly implies that it has the same interface as Spreadsheet::ParseExcel. That module documents that the value() method and the unformatted() method work as described in this thread.
| [reply]
[d/l]
[select] |
| [reply] |
| [reply] |
