PHP Classes

Solved Error with excel2010

Recommend this page to a friend!

      Excel XML  >  All threads  >  Solved Error with excel2010  >  (Un) Subscribe thread alerts  
Subject:Solved Error with excel2010
Summary:Solved Error with excel2010
Messages:2
Author:Alexandre Polesi
Date:2013-07-20 04:25:15
Update:2014-04-04 14:15:45
 

  1. Solved Error with excel2010   Reply   Report abuse  
Picture of Alexandre Polesi Alexandre Polesi - 2013-07-20 04:25:15
I used an xml file that had the line:
<Table ss: ExpandedColumnCount = "255" ff: ExpandedRowCount = "697" x: FullColumns = "1"

But when I changed a single value of cell A12, the class changed the line to:
<Table ss: ExpandedColumnCount = "1" ss: ExpandedRowCount = "12" x: FullColumns = "1"

This numbers are clearly wrong. The excel not open the file.

I Changed the class from this:
$ this-> setTableNodeAttributes ($ tableNode, $ row, $ col);

to this:
$ columnCount = $ tableNode-> getAttribute ("ss: ExpandedColumnCount");
$ rowCount = $ tableNode-> getAttribute ("ss: ExpandedRowCount");

$ this-> setTableNodeAttributes ($ tableNode, max ($ row, $ rowNodes-> length, $ rowCount), max ($ col, $ colNodes-> length, $ columnCount));

and work.


  2. Re: Solved Error with excel2010   Reply   Report abuse  
Picture of Herry Ramli Herry Ramli - 2014-04-04 14:15:46 - In reply to message 1 from Alexandre Polesi
Hi Alexandre,

Apologies for my "very" late reply. I've fixed the codes based on your suggestion. Please check the files and let me know if you find another problem.

Thank you,
Herry