asked on

Convert XML to excel12book

How can I convert an XML to excel12book (Excel 2010)? When I search for it, I can see some examples but can't make out if they would convert to excel12book or excel8book.

I am only interested in excel12book, so wanted some relevant examples.

Thanks in anticipation.

ASKER CERTIFIED SOLUTION

Gertone (Geert Bormans)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ank5

ASKER

Thank you.

Can you please share an example/tutorial of using XSLT to transform to Stylesheet XML 2003

Gertone (Geert Bormans)

well, there is a whole bunch of overehad that needs copying and you require some decent namespace understanding for that.
Please post a simple XML to start from as an example

ank5

ASKER

Thank you very much for the explanation.
Here is a simple explanation. To start with, I would like to just print values c1, c2 and c3 and three different rows in the excel

<?xml version='1.0' encoding='UTF-8'?>
<result>
  <settings>  
    <variable name="$user_name$">S1</variable>
    <reportname>Client Info</reportname>
  </settings>
  <objects name="Client Capability">
    <object>
      <group_name type="string">c1</group_name>
    </object>
    <object>
      <group_name type="string">c2</group_name>
    </object>
    <object>
      <group_name type="string">c3</group_name>
    </object>
  </objects>
  <objects name="Execution Details">
    <object>
      <user_name type="string">user1</user_name>
      <exec_date type="time">2016/12/12 09:20:02</exec_date>
    </object>
  </objects>
  <objects name="Count">
    <object>
      <cnt type="double">3</cnt>
    </object>
  </objects>
</result>

Open in new window

Gertone (Geert Bormans)

Hi, you continued your work while I was asleep, which is good ;-)
I have put a solution in your follow up question
https://www.experts-exchange.com/questions/28989101/Transform-XML-to-Excel-using-XSL.html