Avatar of Matt Jones
Matt Jones
Flag for United States of America asked on

Writing an XML outfile file from an Excel or text input file

Hi,

1. I have an Excel file with 20+ columns.

2. I need to write an XML (output) file which is based on the Excel (input).

3. The SAME (selected) columns from EACH row provide blocks for the XML file.

4. What would be the best tool for this job? AWK? Perl? VBA?

5. If need be, I can also start with a text file (instead of Excel).

Once this question is answered, I will open a follow on question with actual code / script requests.
XMLPerlScripting Languages

Avatar of undefined
Last Comment
wilcoxon

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Theo Kouwenhoven

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
wilcoxon

It's certainly possible to do similar in perl.
Your help has saved me hundreds of hours of internet surfing.
fblack61