Looking for XML enabled Spreadsheet program

  • Thread starter Thread starter Jan Arkesteijn
  • Start date Start date
J

Jan Arkesteijn

Hi
Can anybody point me to a free Spreadsheet program that
can work with XML formatted data files

See you, Jan
 
Hi
Can anybody point me to a free Spreadsheet program that
can work with XML formatted data files

See you, Jan
Click to expand...
OpenOffice (www.openoffice.org) uses XML as it's file format and does
much more than you are asking for but includes a very adequate
spreadsheet program.
 
Martin P Matthews said:
OpenOffice (www.openoffice.org) uses XML as it's file format and does
much more than you are asking for but includes a very adequate
spreadsheet program.
Click to expand...

Hi Martin
Thanks for your reply.
I have downloaded and installed the OpenOffice spreadsheet program
'Calc', but I don't see how it can solve my problem.
Maybe I did ask the wrong question, so I try it again

I have a database that has a structure as the sample below

<d CLOCK_SECOND="0" AIRSPEED="84.91840" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.17244"/>
<d CLOCK_SECOND="1" AIRSPEED="90.79639" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.19255"/>
<d CLOCK_SECOND="2" AIRSPEED="96.63725" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.21362"/>
<d CLOCK_SECOND="3" AIRSPEED="102.12827" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.23424"/>
<d CLOCK_SECOND="4" AIRSPEED="107.75985" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.25648"/>
<d CLOCK_SECOND="5" AIRSPEED="113.47553" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.27968"/>
<d CLOCK_SECOND="6" AIRSPEED="119.12814" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.30355"/>
<d CLOCK_SECOND="7" AIRSPEED="124.55315" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.32701"/>
<d CLOCK_SECOND="8" AIRSPEED="129.69731" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.34999"/>
<d CLOCK_SECOND="9" AIRSPEED="135.03490" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.37439"/>
<d CLOCK_SECOND="10" AIRSPEED="140.52333" VERTICAL_SPEED="0"
PLANE_PITCH_DEGREES="0.40008"/>
<d CLOCK_SECOND="11" AIRSPEED="145.38356" VERTICAL_SPEED="80"
PLANE_PITCH_DEGREES="-0.25201"/>
<d CLOCK_SECOND="12" AIRSPEED="149.92384" VERTICAL_SPEED="98"
PLANE_PITCH_DEGREES="-2.50546"/>
<d CLOCK_SECOND="13" AIRSPEED="154.21196" VERTICAL_SPEED="219"
PLANE_PITCH_DEGREES="-6.32508"/>
<d CLOCK_SECOND="14" AIRSPEED="157.73544" VERTICAL_SPEED="345"
PLANE_PITCH_DEGREES="-10.28239"/>
<d CLOCK_SECOND="15" AIRSPEED="160.78381" VERTICAL_SPEED="888"
PLANE_PITCH_DEGREES="-13.98069"/>
<d CLOCK_SECOND="16" AIRSPEED="164.60089" VERTICAL_SPEED="1851"
PLANE_PITCH_DEGREES="-13.92001"/>
<d CLOCK_SECOND="17" AIRSPEED="166.94545" VERTICAL_SPEED="2620"
PLANE_PITCH_DEGREES="-13.02497"/>
<d CLOCK_SECOND="18" AIRSPEED="168.65248" VERTICAL_SPEED="3013"
PLANE_PITCH_DEGREES="-12.85373"/>
<d CLOCK_SECOND="19" AIRSPEED="169.41568" VERTICAL_SPEED="3180"
PLANE_PITCH_DEGREES="-15.97165"/>
<d CLOCK_SECOND="20" AIRSPEED="170.40431" VERTICAL_SPEED="3689"
PLANE_PITCH_DEGREES="-18.29895"/>

This type of data is coming from a kind of (flight simulation) flight data
recorder
I want to get all CLOCK_SECOND data, BUT ONLY THE NUMBER PART in 1
spreadsheet column
and all the AIRSPEED data (again ONLY the number part) in a next column of
the spreadsheet.etc. etc.
After that it will be easily to get a a graphical presentation of airspeed
versus time etc etc

Can Calc or any other freeware program do this trick ???

See you, Jan
http://home.wxs.nl/~jarkest/home.html
 
I want to get all CLOCK_SECOND data, BUT ONLY THE NUMBER PART in 1
spreadsheet column
and all the AIRSPEED data (again ONLY the number part) in a next column of
the spreadsheet.etc. etc.
After that it will be easily to get a a graphical presentation of airspeed
versus time etc etc
Click to expand...

I suggest you visit www.openoffice.org and have a look around there.
Also look at newsgroups - staroffice is Sun's version of the same
package (ish) and so newsgroups for staroffice should have people who
can answer that question. If anything can I suspect ooo can but I
haven't got the time this morning to find out.

Is it possible to do it by recording a macro which opens the cell for
editing and then searches for a character (e.g. is there a space between
the figure and the text) and then copies the figures into another
column?
 
Back
Top