<Pavanbhatara@g...> wrote in message 
news:1173672835.827704.89920@c......
> Hi,
>
> I have a xml file like this I want to create a spread sheet xml.Can
> anybody help me in writing the xsl for this.

Probably yes, in case you provide a complete (but the smallest possible) 
example of both a source xml document and the (complete) desired result from 
the transformation.

Do not rely that anybody would know what ''spread sheet xml" IS.


Cheers,
Dimitre Novatchev






>
>
>
> <Forms FileID="16209" FormStage="1" FormStatus="1" FormStageName="Data
> Collection" UniqueID="4a97e776-04e4-4ac2-a2d8-8235161650c0"
> LatestFlg="1" ActiveFlg="1" RFIID="5552" PUniqueID="8178ec14-
> ead2-4640-9c45-45ea08b4cd4b"
> StartFlg="1" ReportDate="2007-01-31 00:00:00" TGSD="2007-01-31
> 00:00:00" TGED="2007-01-31 00:00:00"
> CorpID="0" Version="1" SessionID="5536459b-fe07-4e9d-a679-
> b4c61549a913"
> ORCHCONTEXTEMAILID="ORCE0A69A6A286A4149A64A4273A9586A0A0A403@r..."
> DTDXMLPATH="E:\APPS\Orchestra\OrchestraWeb\English\Cache
> \0\10075184494243247621175081821662042166154935715144\1\DTDXML.XML">
> <C RT="Land_3D_Vibroseis" RD="2007-01-31 00:00:00" PS="2007-01-31
> 00:00:00" PE="2007-02-09 00:00:00"
> APCOUNT="0" SUBCOUNT="0">
> <PT>NEW_ARE_OEP_3LV_50125_Phani 903</PT>
> <B BD="6890" BN="blk3" />
> <CS CD="6889" CN="New3" />
> <A AD="6891" AN="area3" />
> <CC CM="6398" CI="Anadarko Petroleum Corporation" />
> <CR CP="6293" CA="Anadarko Petroleum Corporation" />
> <V />
> <CW />
> <P>
> <PR />
> <O OU="67" OE="phaneendra.bonda@p..." OFN="phani"
> OL="bonda" />
> <R RU="69" RE="phaneendra.bonda@b..." RF="phaneendra"
> RL="bonda" />
> <PM PU="69" PA="phaneendra.bonda@b..."
> PF="phaneendra" PL="bonda" />
> <GS>
> <G GSID="3419" GU="69" GE="phaneendra.bonda@b..."
> GF="phaneendra" GL="bonda" />
> </GS>
> <CG>
> <CH CGID="3420" CU="69" CV="phaneendra.bonda@b..."
> CF="phaneendra" CL="bonda" />
> </CG>
> <RP>
> <RS RPID="3719" RR="69" RM="phaneendra.bonda@b..."
> RN="phaneendra" RA="bonda" />
> </RP>
> </P>
> </C>
> <MN>
> <DR>
> <SP>
> <RC CJ="23121" SR="23121" RB="1321" DMK="23121" />
> <ST />
> <SO LS="2312312" SN="231321" NO="2312" SY="1321" />
> <NA />
> <FO IL="53151" XL="2312" NM="23132" />
> <RV LR="2312312" SF="1231" NL="1231" NG="231231" SU="231jhgh" />
> <FL />
> </SP>
> <PP>
> <TR AC="0" AW="0" AM="0" ASR="0" DV="0" />
> <CK AO="0" AE="0" AH="0" AU="0" DI="0" />
> <KM AQ="0" AK="0" AB="0" AV="0" DL="0" />
> <PO />
> <SH AA="0" AZ="0" CZ="0" CQ="0" DE="0" />
> <KL KA="0" KW="0" KC="0" KS="0" KD="0" />
> <VP VA="0" VC="0" VM="0" VS="0" VD="0" />
> </PP>
> <MA>
> <TV TA="0" TC="0" TM="0" TS="0" TG="0" />
> <KK KO="0" KV="0" KH="0" KU="0" KG="0" />
> <KB KE="0" KF="0" KI="0" KJ="0" KQ="0" />
> <PC />
> </MA>
> <FF />
> <BT BK="0" BM="0" BA="0" BB="0" BH="0" BW="0" BR="0" BS="0" />
> <LP />
> <LV />
> <DN>
> <DS DT="0" DC="0" DM="0" DU="0" DG="0" />
> <LF LG="0" LW="0" LH="0" LU="0" LI="0" />
> <LJ LQ="0" LX="0" LZ="0" SJ="0" DB="0" />
> <KZ TD="0" TB="0" TH="0" TK="0" TN="0" />
> <PH />
> </DN>
> <SK>
> <SM SQ="0" SX="0" SZ="0" U="0" />
> <L TU="0" TW="0" TX="0" TY="0" />
> <MM MT="0" MW="0" MO="0" MV="0" />
> <PQ />
> </SK>
> <S>
> <RG RH="0" RJ="0" RK="0" RO="0" />
> <IE IT="0" IA="0" IM="0" ASU="0" />
> <MC ME="0" MF="0" MH="0" MJ="0" />
> <RX />
> </S>
> <UA>
> <UR UO="0" UW="0" UM="0" US="0" UV="0" />
> <UG UY="0" UC="0" UN="0" UU="0" UE="0" />
> </UA>
> <E ET="0" EA="0" EC="0" ES="0" ED="0" />
> <GO GA="0" GR="0" GC="0" />
> <IN>
> <IG IH="0" IK="0" />
> <ID IF="0" IJ="0" />
> <IR IU="0" IW="0" />
> <IZ I="0" M="0" />
> <GB H="0" HK="0" />
> <HG HO="0" HM="0" />
> <HT />
> </IN>
> <N>
> <NR NH="0" NK="0" />
> <ND NF="0" NJ="0" />
> <NQ NT="0" NW="0" />
> <NZ HS="0" HB="0" />
> <HF HJ="0" HP="0" />
> <BE HV="0" HW="0" />
> <HZ />
> </N>
> <DH />
> <OJ>
> <EE />
> <EB />
> <EM />
> </OJ>
> <GT GM="0" GD="0" GH="0" GK="0" F="0" FI="0" FN="0" FR="0" BF="0"
> BG="0" BJ="0" BO="0"
> FB="0" FD="0" FU="0" FX="0" />
> <QAC />
> <GV GW="0" GX="0" GZ="0" JR="0" JL="0" JI="0" JE="0" JS="0" BQ="0"
> BU="0" BX="0" BZ="0"
> WE="0" WQ="0" WH="0" WS="0" WB="0" WC="0" WF="0" WI="0" WR="0"
> WW="0" WL="0" WO="0"
> WT="0" WU="0" W="0" WY="0" UX="0" UZ="0" JM="0" JB="0" JG="0"
> JH="0" JK="0" JT="0"
> JV="0" JX="0" JZ="0" OW="0" OY="0" OZ="0" QU="0" QS="0" QT="0"
> QR="0" QH="0" QB="0"
> QI="0" QE="0" QG="0" QK="0">
> <UP UF="0" UH="0" UJ="0" UL="0" />
> </GV>
> <Q VO="0" K="0" VH="0" VU="0" />
> <VG VJ="0" VK="0" VQ="0" VW="0" />
> <VY VZ="0" XW="0" XM="0" XH="0" />
> <XR XT="0" XK="0" XO="0" XV="0" />
> <XI XD="0" XC="0" XG="0" XJ="0" />
> <XX>
> <XY XZ="0" YN="0" YM="0" YI="0" YF="0" YA="0" YC="0" YS="0" YT="0"
> YW="0" YB="0" FAT="0"
> YD="0" YG="0" YJ="0" YK="0" YL="0" YO="0" YP="0" YQ="0" YU="0"
> YV="0" YX="0" YY="0"
> YE="0" YZ="0" Y="0" Z="0" YH="0" YR="0" ZM="0" ZH="0" RWD="0"
> RWW="0" RWM="0" RWS="0"
> LWD="0" LWW="0" LWM="0" LWS="0" IDX="0" IIW="0" IMM="0" IIS="0"
> YHD="0" YRW="0"
> ZMM="0" ZHS="0" />
> <ZC ZD="0" ZR="0" ZI="0" ZL="0" ZA="0" ZU="0" ZT="0" ZS="0" ZB="0"
> ZF="0" ZG="0" ZE="0"
> ZJ="0" ZK="0" ZN="0" ZO="0" ZP="0" ZQ="0" RIR="0" ZV="0" PRD="0"
> PRW="0" PRM="0"
> PRS="0" RIDD="0" RIW="0" RIM="0" RIS="0" TKD="0" TKW="0" TKM="0"
> TKS="0" ZBD="0"
> ZFW="0" ZGM="0" ZES="0" ZJD="0" ZKW="0" ZNM="0" ZOS="0"
> JPLTSD="0" JPLTSW="0" JPLTSM="0"
> JPLTSS="0" DPLTSD="0" DPLTSW="0" DPLTSM="0" DPLTSS="0" GPLTSD="0"
> GPLTSW="0" GPLTSM="0"
> GPLTSS="0" BDGKD="0" BDGKW="0" BDGKM="0" BDGKS="0" PWCD="0"
> PWCW="0" PWCM="0" PWCS="0"
> MKGD="0" MKGW="0" MKGM="0" MKGS="0" MDKD="0" MDKW="0" MDKM="0"
> MDKS="0" BKGD="0"
> BKGW="0" BKGM="0" BKGS="0" OKGD="0" OKGW="0" OKGM="0" OKGS="0" />
> </XX>
> <ZW>
> <ZX />
> <SEA />
> <GEN />
> </ZW>
> <PDS />
> <COM />
> </DR>
> </MN>
>
> </Forms>
>