Colect data from rs232

[ruijc]

Hi all,

This may not be the right place for this thread but...

I have build a small circuit with a 8pin pic that colects data ( into it's internal eeprom ) from a temp sensor and i need to dump it all in my pc via serial port.

I sucessfuly dumped all data in a txt file but its just a big mess.

I would like to dump it all directly to an excel sheet. From there i could read easly the data and build graphs.

Does anyone has something like this ?

I'm trying to avoid comercial programs...

thanks
.

[Dave]

ruijc, All you need to do is dump the readings in a comma delimited form (commas in between each reading) with a carrage return at the end of the line. That will fill 1 row of your excel spread sheet. I use this method all of the time. Then just inport it into excel with the comma delimited qualifier and bingo, your all done....

Dave Purola,
N8NTA

[ruijc]

Hi Dave,

That's one way to do it...
and easy too
thanks

I've been looking all over the net but coudnt find anything.

I did find an interesting excel sheet with graph already build.
It's called RS232 Scope V1.02 but it doesnt work with windows XP

.

[ruijc]

Hi Dave,

i tested your method and it works

the only problem is that, since it will fill in one row i get limited imported readings.

Excel's rows are limited.

If there was a way to import directly into collumns i could get virtually unlimited reading in.

.

[skimask]

Hi Dave,
i tested your method and it works
the only problem is that, since it will fill in one row i get limited imported readings.
Excel's rows are limited.
If there was a way to import directly into collumns i could get virtually unlimited reading in.
.

Carriage return after every data reading instead of a comma?

[mister_e]

nah it works... depending how you send your data.

look how a excel table is made, Line/Column right?

paste this one in notepad, then import it in excel

COLUMN1	COLUMN2	COLUMN3	COLUMN4
0X00	0X01	0X02	0X03
0X10	0X11	0X12	0X13
0X20	0X21	0X22	0X23
0X30	0X31	0X32	0X33

Here i used space, you can use space, comma, semicolon

Now it should give you some light!

[ruijc]

OK guys,

i know now were i missed.
You have to give me credit...this is not my native language

"Carriage return after every data reading instead of a comma"

So... if have something like :

debug ",",#va ( using comma to separate each value )

i should have:

debug #va, $13 ( being 13 hexa code for carriage ) ?
EDIT: 13 for ascii and 0D for hexa.

But what i get is this :

777777777777
( between each 7 i get a square simbol )

.