Skip to Content
0
Former Member
Apr 02, 2010 at 05:52 PM

Using XML Data Export from Excel into Xcelsius

46 Views

Hello all,

I'm trying to take a table in Excel, convert it to an XML Data file, and then use that file as a connection within Xcelsius. The problem is that Excel produces XML in a way which Xcelsius doesn't work with well.

As to my knowledge, Xcelsius likes the following format:

<data>

<variable name="testing">

<row>

<column>Column A</column>

<column>Column B</column>

<column>Column C</column>

</row>

<row>

<column>Data</column>

<column>Data</column>

<column>Data</column>

</row>

</variable>

</data>

The problem is though, when you import this kind of XML file and Excel tries to make a schema from it, it can't tell the difference between the columns, because it is call the same tag, so I can't map it to the necessary structure.

Does anyone have or know of a schema that Excel can use and can import/map to, which could then be used to export and use for Xcelsius?