Is there an easier way to convert a .XML file to .XLS file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The process is to replace manual operations:
1. open a test.xml with Excel
2. save to a test.xls file

Thanks in advance
 
Hi Li,

It can be, when it is the dataset format, than you can,

Read it as a dataset with readXML
Set it using interop in Excel
Write it back as XLS using interop

Scorpion has already done some work for you to set it to Excel
http://www.kjmsolutions.com/datasetarray.htm

I hope this helps?

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top