in reply to How to read XML file and copy it data to an excel sheet

Is running shell script a better solution for this & why?

Why do you ask? As we have no idea why you need to perform this trick how can we tell what is "better"? Is an orange better than a kiwi fruit and why? Same sort of question really.

If you tell us more about your problem domain we may be able to help, but really Corion's answer is the best pointer toward a solution you're likely to get without you giving us more to go on and showing that you have made an effort of your own.

True laziness is hard work
  • Comment on Re: How to read XML file and copy it data to an excel sheet