troubleshooting Question

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

Avatar of Matt Jones
Matt JonesFlag for United States of America asked on
PerlXMLScripting Languages
2 Comments1 Solution424 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Theo Kouwenhoven
Application Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros