Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2007 XML export seems limited by row count

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Automatic Update  
Author Message
K Grytdal

External


Since: Oct 28, 2008
Posts: 1



(Msg. 1) Posted: Tue Oct 28, 2008 4:06 pm
Post subject: Excel 2007 XML export seems limited by row count
Archived from groups: microsoft>public>excel (more info?)

If I make a new XLSX format file, fill a couple columns of data beyond 65536
(2^16) rows, map it using a simple XSD, and use the XML export feature under
the Development Tab, I seem to be limited to 65536 rows.

For example, if my data is exactly 65536 rows of data, I will get an XML
document resulting in those 65536 records.

However, if I try to export 65537 rows, my resulting XML document will only
have data for row 1 (two more over 65536 and I get the first two rows, and so
on).

Excel 2007 supports 2^20 (over a million) rows of data, but appears to be
limited to 2^16 rows for XML export. Is there something I am doing
incorrectly? Is there a fix to this that does not involve using multiple
work sheets?

 >> Stay informed about: Excel 2007 XML export seems limited by row count 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Export to excel 2007 ASP.NET - Hi, I trying to export the gridview data to excel 2007 it is working fine in windows xp prompting a dialogbox save, cancel,open, when we are accesing the url from client machine where windows vista has got installed on it, it is not asking for..

Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..

Excel 2007 "Trusted Locations" - Is there any way to get Excel 2007 to let you use removable media as a "trusted location"? my a*istant has a Zip drive hooked to her PC that she's using as basically an external hard drive, but whenever she opens a saved spreadsheet, it alw...

Excel 2007 Won't print some borderlines - I am attempting to print a spreadsheet of accounts on which I have used a dotted line (Rt-click / Format Cells/ Borders / Line) so that the accountant can easily follow the lines of income and expenditure. They all show up fine on the Print Preview..
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]