Exporting from Excel 2007 (xlsx format) to XML

A

AlanCrawford

Hi all,
Does anybody know how to export from an XLSX formatted document to
XML? My Excel document has around 250,000 rows, when I export the document to
XML it will only export around 45,000 rows (45,105 to be precise). This
happens everytime I try the export. If I create a new document, with one
column, mapped using the XML map tool in Excel 2007, and put 100,000 unique
numbers in that column, then export to XML, only around 50,000 rows are
exported. The XML is correctly formatted and no error messages appear during
the export. Any help on this would be greatly appreciated.

Best wishes,
Alan Crawford
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Excel 2007 XML export seems limited by row count 0
Export to XML 0
Help Creating XML File from Spreadsheet 1
Export query to Excel fails 5
Export to XML is not exporting all records 0
Excel 2007 - import/export XML (Developer tab) 0
Importing xml file to excel 2

Top