Exporting denormalized data to XML

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Thelwell - 02 Oct 2007 15:01 GMT

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 to this Message

Stan Gibbs - 02 Oct 2007 16:33 GMT

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?

Signature

Stan

> Hi,
>
[quoted text clipped - 42 lines]
>
> AT

Reply to this Message