I'm using
...
use Spreadsheet::XLSX;
use Spreadsheet::XLSX::Fmt2007;
use Spreadsheet::XLSX::Utility2007; ...
to parse an xlsx spreadsheet where a cell contains the value () appear in Description
When I look at the value returned, it looks like this: <Message Name> (<Internal Name>) appear in Description
This does not happen when the spreadsheet is an xls (2003 format). I tried using Notepad and Textpad to see what the xlsx stores, but it's all gibberish. I'm using the following to return the value of the cell
... $cell = $sheet -> {Cells} [$row] [$col]; ... $source_val3_col_val = $cell -> {Val};
Any thoughts or suggestions would be appreciated. I've looked through most of the libraries I'm using and haven't come across the code that converts the strings, so my first thought is that xlsx is storing the &xx; values.
