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?