search

mortenbra / alexandria-plsql-utils

Oracle PL/SQL Utility Library
778 stars 316 forks source link

ooxml_util_pkg XLSX functions return XML encoded strings #27

Open eaolson opened 8 years ago

eaolson commented 8 years ago

If an Excel file contains special characters, they are returned with XML-encoding intact. For example, if my cell contains Special Characters: 'apos &amp <lt >gt "quot, then get_xlsx_cell_value returns Special Characters: &apos;apos &amp;amp &lt;lt &gt;gt &quot;quot. I believe this is because internally it uses .getstringval().

datRedHeadedGuy commented 5 years ago

A pull request has been submitted for this.