DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 13 of 13

Thread: XML & Excel 2003

  1. #1
    Join Date
    Aug 2007
    Posts
    58

    Question XML & Excel 2003

    I am trying to import an XML file into Excel. The import goes fine, but once I am ready to export the file back to XML, I get an error message "Mapped Data is not Exportable".

    I am very new at XML, and I have been working on this issue for weeks. If anyone could help guide me in the right direction I would really appreciate a great deal.

    Thank you in advance.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    What code are you using for the export?

  3. #3
    Join Date
    Aug 2007
    Posts
    58
    When you say code, what do you mean?

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    I'm assuming that you are doing the importing/exporting using programming code, as in Excel VBA, or some other kind of programming language. That code.

    If you are not, then how are you performing these tasks?

  5. #5
    Join Date
    Aug 2007
    Posts
    58
    I believe I have determined that Excel is having issues with the repeating data.

  6. #6
    Join Date
    Aug 2007
    Posts
    58
    I am using the import/export option in Excel, but not by any VBA code. I am importing/exporting the data by the following....

    Data Menu -> XML -> Import (I do the same in order to export).

    I am getting the "List of lists" error message. This is why I am getting the "Mapped data is not exportable" error.

  7. #7
    Join Date
    Aug 2007
    Posts
    58
    As long as I do not have the repeating objects/data, the Excel file will export out to an XML file just fine. It is when there ia repeating objects/data that I begin to get all the export errors.

    Does anyone know how to resolve or workaround the errors?

  8. #8
    Join Date
    Aug 2007
    Posts
    58
    If I can find a way to resolve the repeating objects/data issue, then I believe I will be able to resolve this issue all together.

    Does anyone have any ideas?

  9. #9
    Join Date
    Aug 2007
    Posts
    58
    Would it help if I posted an example file?

  10. #10
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    It couldn't hurt.

  11. #11
    Join Date
    Aug 2007
    Posts
    58
    I have attached an example XML file, as well as, an Excel file with the XML imported.
    Attached Files Attached Files

  12. #12
    Join Date
    Aug 2008
    Posts
    3
    I'm assuming that you are doing the importing/exporting using programming code, as in Excel VBA, or some other kind of programming language. That code.

  13. #13
    Join Date
    Aug 2007
    Posts
    58
    No. I am using the XML menu import/export. I have tried to come up with an Excel VBA, but have been unsuccessful so far.

    Any help you may be able to provide would be greatly appreciated.

Similar Threads

  1. problem in opening XML with EXCEL via VB6
    By eranfox in forum VB Classic
    Replies: 5
    Last Post: 08-09-2007, 07:18 AM
  2. Try XML Junction
    By Tim in forum xml.announcements
    Replies: 0
    Last Post: 10-11-2001, 04:00 PM
  3. Data Junction Announces XML Junction 7.51
    By Tim Frost in forum xml.announcements
    Replies: 0
    Last Post: 04-02-2001, 10:53 AM
  4. Check out Turbo XML: Free trial download
    By Extensibility in forum web.announcements
    Replies: 0
    Last Post: 07-20-2000, 06:20 PM
  5. Check out Turbo XML
    By Sales in forum xml.announcements
    Replies: 0
    Last Post: 07-20-2000, 06:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center