Excel 2007 export as XML size limit/bug
 

There appears to be a limit/bug in the number of rows that Excel 2007 will
export as XML.

Steps to reproduce the error:
1) Create a spreadsheet with a single column and fill the column with
100,000 rows of data
2) Map the XML sample schema to the column (schema provided below)
3) Export the data as XML
4) Open the XML file you exported and only 34464 rows will be present (not
the 100,000 rows created in step 1)

Does anyone know a fix or workaround for this issue?

-Erik


Sample Schema:
<?xml version="1.0" encoding="utf-8"?
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
<xsd:element nillable="true" name="Demo"
<xsd:complexType
<xsd:sequence minOccurs="0"
<xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true"
name="Records" form="unqualified"
<xsd:complexType
<xsd:sequence minOccurs="0"
<xsd:element minOccurs="0" nillable="true" type="xsd:integer"
name="record" form="unqualified"</xsd:element
</xsd:sequence
</xsd:complexType
</xsd:element
</xsd:sequence
</xsd:complexType
</xsd:element
</xsd:schema