Printable View
Hello All,
I am looking at the 16F88 PIC for data logging and serial TX to a PC logging the ADC to an EXCEL document. I can manage the ADC to serial TX, what I need help with is the PC side in taking the serial data and decoding it and dumping it in an EXCEL doc. I want to use 4 ADC channels at 8 to 10bits.
I would appreciate any help/info.
Best Regards,
Nick
If you send out your data with either tabs or commas between columns, and carriage returns between lines, it will line up nicely in Excel.
Google around for 'excel serial port input' and I think you'll find a utility or two which will handle the PC side nicely.
John
That's an option OR you'll need to do VB(or else) program that will get data from serial and create a XCEL or ACCESS file.
I have some PDF on how using/programming VB here. My favorite is the 'VB Black BOOK' almost everything is covered in. I guess you can find that one or else VB EBOOK on some peer-to-peer site like LimeWire Case not send me your e-mail on my PM.
A short VB tutorial on Reynolds Electronics Website.
Probably Hyperterminal, RealTerm can also do the job.