<?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,