![](templates/subSilver/images/CCSLogo.jpg) |
![CCS C Software and Maintenance Offers](templates/subSilver/images/forumAd6.jpg) |
View previous topic :: View next topic |
Author |
Message |
PrinceNai
Joined: 31 Oct 2016 Posts: 466 Location: Montenegro
|
data from serial port to excel |
Posted: Fri Dec 28, 2018 4:28 pm |
|
|
Dear All,
I'm currently breaking my head over a problem with an A6 GSM module. One out of 20 or so times it just doesn't send the message, the program hangs. Of course it never ever happens when I'm looking into the terminal spying for a mistake in my code or for an unexpected answer from the module itself. So I went looking for something free that would write serial data directly to Excel or Access and came across this:
http://individual.utoronto.ca/ddubins/GetCSV.xlsm
on this page:
https://playground.arduino.cc/Main/Excel
It works as a charm. All credits to Mr. or Ms. dndubins
Best regards and happy New Year,
Samo |
|
![](templates/subSilver/images/spacer.gif) |
temtronic
Joined: 01 Jul 2010 Posts: 9181 Location: Greensville,Ontario
|
|
Posted: Sat Dec 29, 2018 6:18 am |
|
|
I went the PIC hardware method. Used a 'datalogger' (Vinculum, years ago...others sell cheaper modules) connected to a spare serial HW port. Even at 115k200 I never lost a bit of data over years of logging. By storing it in CSV format, it was instantly imported into spreadsheet.
The problem I saw using PIC->TTLUSB device->serial ap->eXcel was that unless the PC is very, very 'lean and clean' you'd lose data. There's a LOT of code between the PIC and the spreadsheet. First the PC has to properly control the USB side of the interface, then there's the 'serial ap' that unless you've got the complete source code, you can't debug, then of course Windows. It has to control all this. Not a hard task BUT if it's also looking for emails, doing background updates, surfing the web, running the PICIDE...well, Windows is known for 'dropping the ball'.
Now I did use RealTerm to display/log data from a PIC when I misplaced the Vinculum last year. It properly displayed the data and stored it in a file. I could also 'look back' in the buffered data to see what I needed.
just some options...
Jay |
|
![](templates/subSilver/images/spacer.gif) |
Ttelmah
Joined: 11 Mar 2010 Posts: 19388
|
|
Posted: Sat Dec 29, 2018 6:25 am |
|
|
Yes. In fact if you read the comments by the creator of the script used to do this, he had problems over 9600bps. Like you, I quite commonly generate comma deliminated files to allow data to be directly imported into a spreadsheet for display, and find keeping the handler 'simple' the way to go for reliable fast transfers. |
|
![](templates/subSilver/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|