Doubts with the CSV Writer function
-
- Posts: 2
- http://meble-kuchenne.info.pl
- Joined: Mon Oct 04, 2021 5:23 pm
Doubts with the CSV Writer function
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?
-
- Matrix Staff
- Posts: 1916
- Joined: Wed Dec 02, 2020 11:07 pm
- Has thanked: 621 times
- Been thanked: 644 times
Re: Doubts with the CSV Writer function
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.
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.
Martin
Re: Doubts with the CSV Writer function
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
-
- Valued Contributor
- Posts: 1001
- Joined: Wed Dec 02, 2020 10:53 am
- Has thanked: 190 times
- Been thanked: 217 times
Re: Doubts with the CSV Writer function
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
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