solution the "cannot save or export XML data" error in excel

to master excel,

Please help me so I can solve the problems I am experiencing. Dear All master excel I do not know what this problem can be solved in an excel application with a formula or some other way. My goal is to update the data in excel so that it can be exported to xml. From the xml is then imported into the software. I hereby attach the xml file. Thank you very much.

Rgrds Kana

Please Login or Register  to view this content.

after change declaration to: < ? xml version="1.0" encoding="UTF-8" ? >

Please Login or Register  to view this content.

Well formed:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Validate Document:

Please Login or Register  to view this content.

so you need to check you xml first

Dear master excel/ mr. sandy




The previous file is the contents of the xml file I copied to the text document so it is not appropriate.

With this I attach the excel file and the xml to which I can update the data in excel so that I can export from excel to xml data.

Rgrds


Kana

Originally Posted by roykana

I can update the data in excel so that I can export from excel to xml data.

so where is the problem if can do everything?

btw.
NMEXML_Map is not exportable because it contains the following:
• List of lists
• Denormalized data
• A mapped element's relationship with other elements cannot be preserved

Dear Master excel


sorry I mistake, I can not update the data in excel so that I can not export from excel to xml data.


Please Help me dan give solution

I can not do everything

did you read this?

Originally Posted by sandy666

btw.
NMEXML_Map is not exportable because it contains the following:
• List of lists
• Denormalized data
• A mapped element's relationship with other elements cannot be preserved

to export from xlsx you probably need to create template from your xml.
I don't remeber how Excel 2007 works with xml, sorry
I'll look at this a little later

Originally Posted by sandy666

did you read this?



to export from xlsx you probably need to create template from your xml.
I don't remeber how Excel 2007 works with xml, sorry
I'll look at this a little later

Please help me to make template from excel or can you help me tom make vba code in excel. Please help me

Originally Posted by sandy666

I think you should reorganize your xml if you want to import/export to/from xlsx properly

read here: export xml and it confirms what I said above (post#4, post#7)

If you want to use xml professionally, use professional software like Altova

With software altova, can software connect with excel and xml data can be in one line or one row in one record it making easier to copy the transaction.

You read from my posts what you want to see not what you should do

NMEXML_Map is not exportable because it contains the following:
• List of lists
• Denormalized data
• A mapped element's relationship with other elements cannot be preserved

read description from link above (post#8)

or wait for someone who will help you with VBA

that's all what I can do for you

have a nice day

and stop repeating: please help me - this is annoyed

Originally Posted by sandy666

You read from my posts what you want to see not what you should do

NMEXML_Map is not exportable because it contains the following:
• List of lists
• Denormalized data
• A mapped element's relationship with other elements cannot be preserved

read description from link above (post#8)

or wait for someone who will help you with VBA

that's all what I can do for you

have a nice day

and stop repeating: please help me - this is annoyed

Dear master excel,

Please help me to solve my problem.


Thanks you

Roykana

Originally Posted by sandy666

You read from my posts what you want to see not what you should do

NMEXML_Map is not exportable because it contains the following:
• List of lists
• Denormalized data
• A mapped element's relationship with other elements cannot be preserved

read description from link above (post#8)

or wait for someone who will help you with VBA

that's all what I can do for you

have a nice day

and stop repeating: please help me - this is annoyed

Please help me to make tenplate from xml.

Thks