Creating an XML from Excel

First off, I have very little experience with xml.

I need to run a report in Quickbooks and export it to excel and create an xml report from that.  (New Hungarian tax decree).

How would I map it in order to get the correct data?

I was given an xml field definitions, table of descriptions, a table with 3 columns, Invoice information items(invoice export file particulars), definition, and xsd reference.

Please help. File attached, many pages of this.

Brian
20160121_095044_resized.jpg
LVL 1
Brian_HarperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DougCommented:
Brian,
I noticed that this post hasn't received any views for a while. I don't purport to know anything about XML  but if you haven't tried already, you can use Excel help/tell me box above the ribbon. Enter "xml" and select the Create an XML data file and XML schema file from worksheet data and Map XML elements to cells in an XML Map link for some guidance.

If no one else responds you may want to request attention.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian_HarperAuthor Commented:
Thanks Doug.
Brian_HarperAuthor Commented:
good answer
DougCommented:
Thanks Brian. I hope everything works out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.