Avatar of Matt Jones
Matt JonesFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Theo Kouwenhoven
Theo Kouwenhoven
Flag of Netherlands image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of wilcoxon
wilcoxon
Flag of United States of America image

It's certainly possible to do similar in perl.
Scripting Languages
Scripting Languages

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

30K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo