Shop OBEX P1 Docs P2 Docs Learn Events
exporting logged data to Microsoft Excel — Parallax Forums

exporting logged data to Microsoft Excel

evergreenevergreen Posts: 43
edited 2006-04-22 05:40 in BASIC Stamp
How would one export logged data from an EEPROM to Microsoft Excel (I need to graph the data, and compare it another Excel graph)? Does Stamp Plot Lite have this function?

Thanks

Comments

  • Bruce BatesBruce Bates Posts: 3,045
    edited 2006-04-21 06:59
    evergreen -

    Your choices are (I think) Stamp Plot, StampDAQ, and hyperterminal. The former two are the better bets.

    Regards,

    Bruce Bates

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    <!--StartFragment -->
  • Jon WilliamsJon Williams Posts: 6,491
    edited 2006-04-21 14:05
    You can use DEBUG or SEROUT to send the data (as text) to a terminal program; capture that output, and then import it into Excel. When you do this, use comma-delimited format, and the file with a .csv extension. Here's what the output line might look like:

    DEBUG DEC recNum, ",", DEC xReading, ",", DEC yReading, CR

    ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
    Jon Williams
    Applications Engineer, Parallax
  • dspeerdspeer Posts: 7
    edited 2006-04-22 05:40
    I am running a Serial Logger as a Service on Win2000. Logs all data coming in through the serial port to any ODBC compliant destination (MySQL database in my case). Very handy, no manual steps or logging to EEPROM needed.
Sign In or Register to comment.