r p

r p

  • NA
  • 343
  • 0

Convert XML to Excel

Jun 10 2010 9:47 AM
Hi, 
I want to covert my XML file which is in the following format to Excel:- 

<?xml version="1.0" encoding="UTF-8"?>

<ODM FileOID="All_Data000000" 

Description="abcdefg" CreationDateTime="2010-06-10T13:06:13+01:00" 

FileType="Snapshot" ODMVersion="1.3" xmlns="http://www.cdisc.org/ns/odm/v1.3" 

xmlns:OpenClinica="http://www.openclinica.org/ns/openclinica_odm/v1.3" 

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

xsi:schemaLocation="http://www.cdisc.org/ns/odm/v1.3 OpenClinica-ODM1-3-0.xsd" >


    <Study OID="S_TEST01">

        <MetaDataVersion OID="v1.0.0" Name="MetaDataVersion_v1.0.0">

                  

            <ItemGroupDef OID="IG_VISI_AVERAGE-F_VISI_2" Name="average" Repeating="Yes" SASDatasetName="AVERA003">

                <ItemRef ItemOID="I_VISI_AVERAGE_SYSTOLIC_4218" OrderNumber="1" Mandatory="No"/>

                <ItemRef ItemOID="I_VISI_AVERAGE_DIASTOLIC_3421" OrderNumber="2" Mandatory="No"/>

                <ItemRef ItemOID="I_VISI_AVERAGE_HEART_RATE_8278" OrderNumber="3" Mandatory="No"/>

            </ItemGroupDef>


What is the best way to convert this to Excel? I have nearly 1000 lines like this. How can I make the XSLT for this?

Cheers,