question

FedericoCoppola-2569 avatar image
0 Votes"
FedericoCoppola-2569 asked ·

Excel fails to create XML file

Hi all,
I have an excel file and I would create XML file.
I have a trouble with a date column.

If I add this colum with date (just date dd-mm-yyyy), Excel fails export to XML.

I have found this way as workaround:
1) export in CSV format
2) convert from CVS format to XML using an external tool

I would avoid this workaround if possible.

How can I solve it?
Thanks

Federico

office-excel-itpro
· 1
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


How did you export the data, do you have a corresponding XML Map and what errors did you get?

0 Votes 0 ·

1 Answer

erinding-msft avatar image
0 Votes"
erinding-msft answered ·

@TimCheng-7302

Could you please tell me the version of your Excel?
File>Account>About Excel
47854-1.png

Could you successfully export to XML without adding the date column?

How did you export to XML?
Did you follow the steps in “Export XML data”?

Do you have a XML Map?
Please refer to “Export Excel to XML Tutorial”, it may be helpful for you.
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Besides, is there any error message when failing to export to XML?
If there is, please give the screenshot.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.png (1.6 KiB)
· 1
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@TimCheng-7302

How is your issue going?
Any updates, please let me know.

0 Votes 0 ·