on 04-02-2010 6:52 PM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.