Arduino Excel(formerArduino Excel Commander) is apowerful MS Excel interface toArduino that supports data exchangingin both directions.
![Vba for excel serial communication with arduino programming free Vba for excel serial communication with arduino programming free](/uploads/1/2/5/8/125805701/380715900.png)
'Can anyone supply a code snippet that will allow me to read a digital scale connected to Port 5, 2400 Baud 8-N-2? I have a digital scale that transmits 8 bytes continuously (4 times per second) and I use it to record product weights and calculate postage.
• data writing to any worksheet /cell
• data retrieving from any worksheet / cell
You can useExcel as data logger or input source.
• data retrieving from any worksheet / cell
You can useExcel as data logger or input source.
![Vba For Excel Serial Communication With Arduino Programming Vba For Excel Serial Communication With Arduino Programming](/uploads/1/2/5/8/125805701/984449279.jpg)
The logic is built in the Arduino sketch with instructions like:
// write the x variable value to worksheet 'Example' range 'B5' with two digits as decimals
myExcel.write('Example', 'B5', x, 2);
myExcel.write('Example', 'B5', x, 2);
or
// get the value from worksheet 'Test' range 'A3' and put it in y variable
ret = myExcel.get('Test', 'A3', y);
// get the value from worksheet 'Test' range 'A3' and put it in y variable
ret = myExcel.get('Test', 'A3', y);
The new rExcel library makes all very easy, find more documentation in the sketch supplied as example.
Getting started
· download the setup procedure, run it as Administrator (right click) and follow instructions
· download the setup procedure, run it as Administrator (right click) and follow instructions
Any feedback will beappreciated, if I know how people use my software I can get new ideas
Test also the new appThings Gateway it has more features and adifferent approach