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=\"s5 2\"><Data ss:Type=\"Strin g\"> </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=\"s5 2\"><Data ss:Type=\"Strin g\"> </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 ExpandedRowCoun t 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