PHP Classes

Error loading in Excel

Recommend this page to a friend!

      Excel XML  >  All threads  >  Error loading in Excel  >  (Un) Subscribe thread alerts  
Subject:Error loading in Excel
Summary:When loading in Excel 2007, it returns an XML error message
Messages:2
Author:David
Date:2008-11-18 06:04:23
Update:2008-11-18 09:34:06
 

  1. Error loading in Excel   Reply   Report abuse  
Picture of David David - 2008-11-18 06:04:23
When loading the (huge=22Mb) result file in XL 2007, it returns an XML compliance error message. When opening the XML file, there is alot of <ROW/> tags at the end of the file. Will try to revert in a laodable XML file and give further feedback here.

  2. 2nd: Error loading in Excel   Reply   Report abuse  
Picture of David David - 2008-11-18 09:34:06 - In reply to message 1 from David
After a close try, two problems appears when using this class, do you know why?:

Class is creating the new xml file with returning

<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="5000" x:FullColumns="1" x:FullRows="1" ss:StyleID="s62"> at line 2633

instead of

<Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="27" x:FullColumns="1" x:FullRows="1" ss:StyleID="s62">

(note ExpandedColumnCount and ExpandedRowCount values)

and
<Row/><Row/><Row/><Row/...ow/><Row/><Row/><Row/><Row/><Row><Cell><Data ss:Type="String">Senso(1)</Data></Cell></Row></Table>

instead of

</Table>

(note incredibly high quantity of <Row/> tags and insertion of a ><Row><Cell><Data ss:Type="String">Senso(1)</Data></Cell></Row> tag group that is clearly not in the source file)

Can you help ?

Regards,
David