PHP excel xml report creating using loops

[domka]

hello,
I making xml to excel report using by php. I sow problem and can't fix it.

when i use loop like this
for ($i=1; $i<5; $i++){
echo"<Row><Cell ss:StyleID=\"s52\"><Data ss:Type=\"String\"> </Data><NamedCell ss:Name=\"Print_Area\"/>$i</Cell></Row>";
}
everthing generate ok, but if i use

for ($i=1; $i<11; $i++){
echo"<Row><Cell ss:StyleID=\"s52\"><Data ss:Type=\"String\"> </Data><NamedCell ss:Name=\"Print_Area\"/>$i</Cell></Row>";
}
everthing is stoping and broke excel report generation. How need to fix it?

please help..

thanks in advance

[jkmyoung]

You will probably need to change the following line somewhere in your Excel xml.

<Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="6" x:FullColumns="1" x:FullRows="1">

If the ExpandedRowCount attribute does not match the number of rows you have, excel will throw a validation error.

[domka]

Thank you, jkmyoung . Its works..Thanks for you, jkmyoung