Trouble displaying multiple rows

[kwfeese]

I saved a spreadsheet to xml then wrote a program to populate the data from files we had on our system. The problem I'm having is that when I try to open the xml file in excel, it opens fine if I have 3 or less rows but errors on the fourth row.
When I create the XML file and manually delete the 3rd row so now the 4th row is 3rd, it opens fine so it's not the fourth row that's causing the error.

I'm thinking there is something in the XML structure that's limiting it to just 3 rows but can't seem to find it.

Any help would be greate.

[Radu]

Hi,
I do not have enough details how the structure of your XML file looks like and how you import it in Excel.
Have you tried using XSLT to convert your custom XML file to an HTML table, then open the HTML in a web browser, copy the HTML table from the web browser and paste it in a new Excel spreadsheet?
Regards,
Radu

[kwfeese]

That seems like too much work for the user to have to do to view the spreadsheet.

I can post the XML if that makes it easier.

[kwfeese]

I found the error, it was in the Table tag. After removing the following line, everything fell into place.
ss:ExpandedColumnCount="16" ss:ExpandedRowCount="18" x:FullColumns="1"