XML entities are not encoded

[gegiben]

XML entities are not encoded

[GoogleCodeExporter]

hi,

Any idea to modify or update the existing excel file with php?

Thanks

Original comment by [email protected] on 3 Jul 2009 at 8:02

[GoogleCodeExporter]

@gmeader: Thanks for this report. I am currently trying to address this issue in
version 2:

http://code.google.com/p/php-excel/source/browse/#svn/branches/version02

However, I still need a conversion table to quickly convert special characters 
to the
necessary representation in the used charset. This is a performance issue since
larger arrays will create quite some heavy load when trying to convert every 
single cell.

@almightyad: Modifications will only be possible as long as the file has not 
been
converted to the binary xls-format. It's a great idea, however. It should not 
be too
difficult to read out the Excel-XML into an array using SimpleXML, then making
changes to the structures and values and deliver the result again in an excel
document. I need to think about it.

Original comment by [email protected] on 10 Sep 2009 at 10:04

[GoogleCodeExporter]

I will address this issue with a new version and/or a patch for version 1.

Original comment by [email protected] on 10 Sep 2009 at 12:27

• Changed state: Accepted

[GoogleCodeExporter]

I've tried to fix this with version 1.1. However, I still need to test this
thoroughly. Check the download section at:

http://code.google.com/p/php-excel/downloads/list

Original comment by [email protected] on 10 Sep 2009 at 2:26

• Changed state: Started

[GoogleCodeExporter]

Original comment by [email protected] on 10 Sep 2009 at 3:53

• Added labels: Milestone-Release1.2

[GoogleCodeExporter]

I'm using the following version shipped with a Drupal module to output Excel 
files...

// $Id: php-excel.class.php,v 1.1.2.1 2009/11/04 17:22:40 jkarsum Exp $


... and am seeing this same issue. I notice the addRow function calls 
htmlentities in
order to generate valid XML, but am confused as to why Excel doesn't decode 
these
properly.

Original comment by [email protected] on 29 Apr 2010 at 6:49