Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.office.xml,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Exporting denormalized data to XML
Hi,
I have some data in Excel that is denormalized. Looks like this: RowID RowName RowSegID StartX EndX StartY EndY NumSeats 2 1 2.1 0 7.92 0.2 0.2 16 2 1 2.2 9.1593 17.0798 0.2 0.2 16 3 2 3.1 0 7.92 1 1 16 3 2 3.2 9.1593 17.0798 1 1 16 4 3 4.1 0 7.92 1.8 1.8 16 4 3 4.2 9.1593 17.0798 1.8 1.8 16 I need to export it to XML, in a structure like this: <Rows <Row id="2" name="1" <RowSegment id="2.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="2.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row <Row id="3" name="2" <RowSegment id="3.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="3.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row <Row id="4" name="2" <RowSegment id="4.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="4.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row </Rows At the moment, when I try to achieve this using the XML export feature under the 'Developer XML' button of the ribbon, it does not let me export. The error message complains because the data contains denormalized data. Can anyone tell me if this can be achieved... or do I need to give up now? Many thanks, AT |
#2
Posted to microsoft.public.excel.misc,microsoft.public.office.xml,microsoft.public.excel
|
|||
|
|||
Exporting denormalized data to XML
Andrew,
I'm afraid I can't give you a direct answer to your question, but I would suggest that if there is a way, it is very complicated and you have to be an XML guru to do it. I haven't seen any examples of mapping of cell values to XML attributes in Excel help or newsgroups. I find the use of XML in Excel way too complicated and confusing. For example, if you just load the Example.XML/Example.XSD files that are provided in Excel 2007 help, you can't export the resulting table to XML! You can normalize it (whatever that means) by removing the mapping of the denormalized elements, but then you don't get the employee information! Of what value is that? -- Stan "Andrew Thelwell" wrote: Hi, I have some data in Excel that is denormalized. Looks like this: RowID RowName RowSegID StartX EndX StartY EndY NumSeats 2 1 2.1 0 7.92 0.2 0.2 16 2 1 2.2 9.1593 17.0798 0.2 0.2 16 3 2 3.1 0 7.92 1 1 16 3 2 3.2 9.1593 17.0798 1 1 16 4 3 4.1 0 7.92 1.8 1.8 16 4 3 4.2 9.1593 17.0798 1.8 1.8 16 I need to export it to XML, in a structure like this: <Rows <Row id="2" name="1" <RowSegment id="2.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="2.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row <Row id="3" name="2" <RowSegment id="3.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="3.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row <Row id="4" name="2" <RowSegment id="4.1" startx="0" endx="7.92" starty="0.2" endy="0.2" numseats="16"/ <RowSegment id="4.2" startx="9.1593" endx="17.0798" starty="0.2" endy="0.2" numseats="16"/ </Row </Rows At the moment, when I try to achieve this using the XML export feature under the 'Developer XML' button of the ribbon, it does not let me export. The error message complains because the data contains denormalized data. Can anyone tell me if this can be achieved... or do I need to give up now? Many thanks, AT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting Value Data | Excel Discussion (Misc queries) | |||
Exporting Data | Excel Discussion (Misc queries) | |||
exporting a lot of data | Excel Worksheet Functions | |||
Exporting Data | Excel Worksheet Functions | |||
exporting data | Excel Discussion (Misc queries) |