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.