-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
you can try to build a xslt import filter ... http://www-128.ibm.com/developerworks/xml/library/x-oocalc/ Oliver Am 09.10.2007 17:19 schrieb Richard A. DeVenezia: > I have received an xml file and don't know the rituals needed to get to > appear in calc > > The file looks like this: > > <?xml version="1.0" standalone="yes"?> > <NewDataSet> > <xs:schema id="NewDataSet" xmlns="" > xmlns:xs="http://www.w3.org/2001/XMLSchema"; > xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> > <xs:element name="NewDataSet" msdata:IsDataSet="true" > msdata:UseCurrentLocale="true"> > <xs:complexType> > <xs:choice minOccurs="0" maxOccurs="unbounded"> > <xs:element name="Table"> > <xs:complexType> > <xs:sequence> > <xs:element name="MemberID" type="xs:int" minOccurs="0" /> > <xs:element name="LastName" type="xs:string" minOccurs="0" > /> > <xs:element name="FirstName" type="xs:string" minOccurs="0" > /> > <xs:element name="MiddleName" type="xs:string" minOccurs="0" > /> > <xs:element name="LeagueRating" type="xs:short" > minOccurs="0" /> > <xs:element name="Rating" type="xs:short" minOccurs="0" /> > <xs:element name="ExpirationDate" type="xs:dateTime" > minOccurs="0" /> > <xs:element name="Sex" type="xs:string" minOccurs="0" /> > <xs:element name="Email" type="xs:string" minOccurs="0" /> > </xs:sequence> > </xs:complexType> > </xs:element> > </xs:choice> > </xs:complexType> > </xs:element> > </xs:schema> > <Table> > <MemberID>906675</MemberID> > <LastName>Abraham</LastName> > <FirstName>Byron</FirstName> > <MiddleName /> > <LeagueRating>663</LeagueRating> > <Rating>0</Rating> > <ExpirationDate>2007-07-25T00:00:00-07:00</ExpirationDate> > <Sex>M</Sex> > <Email /> > </Table> > ... lots more <table> for each row > </NewDataSet> > > Any help or pointers is appreciated. > > TIA, > > Richard A. DeVenezia > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHC6l3TiyrQM/QSkURAjAkAJ0ceutwqXq6eoMeXCXD0Wuce+puIwCffaMi grIpIzXxiWRRtkQBr1bttcY= =PZtY -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
