XML with inline schema supported in Excel? -


i need generate simple xml file (a list of users) xsd xml can imported in excel (2010+). fields presented xml dynamic, it's user fields wants/needs. list can long , have 40 fields user can select from.

excel builds table columns based upon xml schema. if first row has missing fields, these added table in wrong order. schema required! since xml based on request, xml schema must inline.

based on every article find inline schema's i've created following.. crash'n burn every validator. excel won't accept either.

<?xml version="1.0" encoding="utf-8"?>  <users xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:nonamespaceschemalocation="#local">   <xs:schema id="local" xmlns:xs="http://www.w3.org/2001/xmlschema">     <xs:element name="users">       <xs:complextype>         <xs:sequence>           <xs:any processcontents="skip" namespace="http://www.w3.org/2001/xmlschema" minoccurs="0" maxoccurs="1"/>           <xs:element ref="user" minoccurs='1' maxoccurs='unbounded'/>         </xs:sequence>       </xs:complextype>     </xs:element>      <xs:element name="user">       <xs:complextype>         <xs:sequence>           <xs:element ref="firstname" minoccurs='0' maxoccurs='1'/>           <xs:element ref="lastname" minoccurs='0' maxoccurs='1'/>           <xs:element ref="phone" minoccurs='0' maxoccurs='1'/>         </xs:sequence>       </xs:complextype>     </xs:element>      <xs:element name="firstname" type="xs:string"/>     <xs:element name="lastname" type="xs:string"/>     <xs:element name="phone" type="xs:string"/>    </xs:schema>    <user>     <lastname>doe</lastname>     <phone>123456789</phone>   </user>   <user>     <firstname>john</firstname>     <lastname>something</lastname>   </user>   <user>     <firstname>jesus</firstname>     <lastname>christ</lastname>     <phone>987654321</phone>   </user> </users>

what heck doing wrong? seems simple...


Comments

Post a Comment

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

i have eclipse maven plugin coming on centos. how can execute maven command on linx like: mvn clean package [abigail@localhost ~]$ mvn bash: mvn: command not found how should specify path executable of maven plugin in eclipse? or have install maven seperately？ thanks. eclipse (m2e) have bundled central parts of maven inside eclipse plugin, why not detected, , not usable. investigation find correct way bootstrap it, have create launcher file manually. if want run maven outside of eclipse, far better off standalone version of maven. mvn command bootstrap maven runtime system correctly, , secondly, able use advice concerning use of maven. maven binaries quite stable, wouldn't need upgrade upgrade eclipse. you can subsequently switch eclipse use external installation if prefer.
Read more

Error while updating a record in APEX screen -

while updating record using mru failing below error. 1 error has occurred current version of data in database has changed since user initiated update process. current row version identifier = "c5f3645b026aa5646c00dc7b631c4d19" application row version identifier = "6a9323b62f641015fa4601421dfb03de" (row 1) this strange because not see change in data @ backend. any highly appreciated. thanks. aj
Read more

c++ - In an add-in in Excel, written in C(++), how does one get the name of the function which called into the addin? -

the title says all. have add-in excel, written in c++, , register several different functions in excel call same extern "c" function in c++, dispatching on function called in excel. so, need able determine excel function called it. edit: since doesn't seem clear: have large plugin library excel, written in c++. extending it, , 1 of things want allow library support plugins itself, possibly written in other languages. (we use python lot higher level things, example.) when load 1 of these plugins, pointer functions need register, along information arguments, return values, etc. need way of registering these functions excel, excel user can access them. basic thought have single function in library, forward desired function (typically python function, i'd marshall excel arguments python list, call python function using pyobject_callobject , , marshall return values xloper12 , return excel. when registering functions, pxprocedure string name of marshall...
Read more