Excel or other computer app to control Arduino servo movements.

Projects General Guidance
1

Hello.

I would like to create an excel (or excel-like) interface to use on my computer for controlling my Arduino and 16 servos.

I want a 16x1 table in which data from an excel spreadsheet can be inserted into known as (Read Data). Each row will be linked to its own servo to control.

Next to the table is a large box for inputting one data set. (Input Data)

Then an Input data is made. I want any matching Read data to highlight itself and activate its corresponding servo.

Then when the next input data is added. All previously activated servos to deactivate, and the new corresponding servos to activate.

I am figuring out the Arduino code, but my biggest problem is creating an interface to control the servos in this way.

I have done some research and tried Roberto Valgolio's Arduino_Excel_12, but cannot get the program to even open. My knowledge of visual studios for creating something like this is very very limited.

My questions are:

. Can someone point me in the direction of something already set up like this that I can edit for my needs?

. Is this actually possible?

. I have been looking into Fiverr to hire some assistance. What kind of skillset do I need?

. Any alternative ideas?

Thank you for your time.

2

I have never used it but whenever this topic comes up, people mention PLX-DAQ.

3

PLX
https://forum.arduino.cc/index.php?topic=437398.0
I understand it has two-way traffic, so It should be what you want.

4

Hello frankehuffer,

There is an application (library + PC program) that does exactly what you need, it is called WawiLib-PC.
It is very simple to use and comes with a lot of manuals and demo's.
It presents an Excel-like table where you can see the actual value of variables in your Arduino board.
You can copy and paste values for excel in the grid of the program, press "write all" and the values are sent to the Arduino board. In parallel with the grid to modify variables, there is an output section that you can use just like with the serial monitor window. You can also record actual values to file csv, xml, or xlsx to monitor what your application does in practice.
There is a free version you can try, and if you like it you can extend the functions for a small fee to compensate for the operation cost of the website, code signing certificate and other costs.
WawiLib supports communication over USB, Serial, SoftSerial, Ethernet and WiFi.
Check out: WawiLib movie for a movie.
Or SylvesterSolutions for more info.
See also WawiLib serial USB getting started for detailed manuals.

Johi, (founder of sylvestersolutions and the author of WawiLib)

Getting started WawiLib programming port V1.6.X.pdf (1.71 MB)

5

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.