..what is the difference in the cell hash for _Value and Val? I open the file with new, no converters, and then step through a sheet's cells. I've had success with these in the past using _Value for the cell contents, but today , suddenly, I saw this:
0 Spreadsheet::ParseExcel::Cell=HASH(0x6669a58)
'Format' => ''
'Type' => 'Numeric'
'Val' => 0.153
'_Value' => 0.15
I checked in excel and indeed, the cell has 0.153 in it, as text, nothing looks unusual.
Should I be using {Val} ? I see the lone example on the module's meta cpan page uses Val, but I see no description of the cell-hash , or what the difference is between Val and _Value?
Can a kind Monk enlighten me?
TYVM