Page 1 of 1

Doubts with the CSV Writer function

Posted: Tue Oct 12, 2021 12:50 pm
by OderSilva
Hello. I have been trying to save the data sent by my PIC microcontroller to my computer in an Excel file, but I have not found any method that works in practice. I read the article on this page https://www.matrixtsl.com/wiki/index.ph ... ime_Tools) but I didn't understand how it works, as I thought the information is not enough. Could someone help me how to automatically save the data sent by pic in an excel spreadsheet?

Re: Doubts with the CSV Writer function

Posted: Tue Oct 12, 2021 3:09 pm
by medelec35
Hi, OderSilva.
The CVS writer is used with App developer and is not designed to be loaded into a microcontroller.

There are two options I can thank of that will allow a microcontroller to write data to a flash drive or an SD card.
I don't know of any way that does not involve a fairly complex script to save data directly on to a PC.
The two options are
1. Vdrive2. That will allow you so save directly on to a USB flash drive,
2. SD card module.
Option 2 is already supported by Flowcode.
The files should ve saved as CSV.

Re: Doubts with the CSV Writer function

Posted: Wed Oct 13, 2021 1:05 am
by OderSilva
Hi Martin. Thanks for your help. I got a solution. There was a software that I was trying to learn how to use, but until the time of posting I had not found success, but some time later I managed to make a correct communication between the computer and the pic microcontroller. The software is the PLX-DAQ from Parallax. It's like a modified excel for this modified one. I am happy for having achieved this goal, as it will facilitate the acquisition of data to obtain calibration curves for equipment and so on. Thank you for your dedication to providing support. Cheers

Re: Doubts with the CSV Writer function

Posted: Wed Oct 13, 2021 8:40 am
by stefan.erni
Hi OderSilva

With so many terminal programs you can simply save a LOG file as an Excel file without installing anything on Excel.
But the best and easiest solution is the app developer from Flowcode.
With a few clicks of the mouse, you can create an app that you can use.
And you can share this app to everyone.
Have a look here
https://maker.pro/arduino/projects/flow ... ata-logger

regards

Stefan