http://www.perlmonks.org?node_id=1022096


in reply to Spreadsheet::XLSX returning &lt; &gt; and &amp; instead of < > &

How are you looking at the value?

What does substr($value, 0,1) look like when you display it using the same method? '&' or '&lt;'?

  • Comment on Re: Spreadsheet::XLSX returning &lt; &gt; and &amp; instead of < > &
  • Download Code

Replies are listed 'Best First'.
Re^2: Spreadsheet::XLSX returning &lt; &gt; and &amp; instead of < > &
by psynk (Initiate) on Mar 07, 2013 at 16:19 UTC
    I see '&' which leads me to believe that's how MSFT is storing it in the xlsx spreadsheets.