locked
Limitation in xml export from Excel 2007? RRS feed

  • Question

  • Hi -

    I have an excel file created in Excel 2007 with values in 65600 rows and it is mapped to a xsd.

    Now, when I export it to XML, I only get 64 rows! Then when I tried with various combinations, I found that it exports only 65536 rows and only if the total number of rows is less than or equal to 65536. Is it a known issue? If so, is there any work around to export the whole work sheet into xml regardless of the number of rows?

     

    Any help is highly appreciated

     

    Thanks,

    Bijoy

    • Moved by Max Wang_1983 Tuesday, April 26, 2011 4:58 PM forum consolidation (From:Windows Error Reporting for ISVs)
    Wednesday, October 22, 2008 5:29 PM

Answers