E
Erik C. Nielsen
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>
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>