| T O P I C R E V I E W |
| schuettlfy |
Posted - 06/02/2005 : 09:47:45 AM
Hello,
I wan't to import xml-like data to a worksheet. The data looks like this:
\BEGIN:{Header}
[Distance&mm&DATA_DOUBLE&1];[X&mm&DATA_DOUBLE&1];[Y&mm&DATA_DOUBLE&1];[Z&mm&DATA_DOUBLE&1];[A&DEG&DATA_DOUBLE&1];[B&DEG&DATA_DOUBLE&1];[C&DEG&DATA_DOUBLE&1];[Fx&N&DATA_DOUBLE&1];[Fy&N&DATA_DOUBLE&1]
\END
\BEGIN:{Data}
0;517.3;-78.52;356.41;3.13287;0.00942478;-0.118682;-0.0017954;-0.00299337
0.00035464;517.3;-78.52;356.41;3.13287;0.00942478;-0.118682;0.000963839
0.000709372;517.3;-78.52;356.409;3.13287;0.00942478;-0.118682;0.000859114
...
(more data)
...
\END
\BEGIN:{Attributes}
[Startposition]&[XVALUE]&[1.188323]
...
(more aattributes)
...
\END
I can read the lines of the data file step by step and can decide if I want to add the line to the worksheet (all between \BEGIN:{Data} and \END) but unfortunately their is no way to add a single row to a worksheet (I think).
Thanks,
Frank
--- skip ---
Dr. Frank Schüttler
www.battenberg.biz
|
| 2 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 06/02/2005 : 7:31:29 PM
if the file is really XML, then you can just load it into the Origin C Tree object, once in a tree, it is easy to manipulate.
CP
|
| Mike Buess |
Posted - 06/02/2005 : 10:55:59 AM
Hi Frank,
Might be easiest to fill the wks by columns then convert to matrix, transpose matrix and convert back to wks.
Mike Buess
Origin WebRing Member |
|
|
