Arduino To Excel Communication

The easiest way: install Parallax then upload the Arduino code.

Mar 20, 2018

62047 views

38 respects

Components and supplies

1

Prototype Expansion Board for Arduino Uno

1

Potentiometer

1

Arduino UNO

1

Jumper Wires

1

USB Cable 2.0 Type A/B for Arduino Uno

1

Breadboard

Project description

Code

Untitled file

c_cpp

Untitled file

c_cpp

Downloadable files

arduino_with_resistor_fONGOlhZpk.jpg

arduino_with_resistor_fONGOlhZpk.jpg

Comments

Only logged in users can leave comments

Anonymous user

2 years ago

i am beginner, in grade 6 school i followed the steps provided and it worked on excel its good thank you

m_karim02

2 years ago

Happy to hear this, You are most welcome

Anonymous user

2 years ago

How to add more columns in this? and get more sensor data values?

m_karim02

2 years ago

Hello Please visit my youtube. There have a lot of videos to add more sensor data.

Anonymous user

2 years ago

interesting project, simple but effective. Well done and thanks for sharing

m_karim02

2 years ago

most welcome

Anonymous user

2 years ago

This sketch only ‘measures’ the voltage at pin A0 and prints it. I don’t see a timer. Why the unnecessary and confusing lines 3, 4, 5 and 9?

m_karim02

2 years ago

yes, you can change delay according to your need.

m_karim02

2 years ago

3,4,5,9 lines for the additional serial print. I am very Sorry if it confuse you. I write for the advanced learners.

AKJ

2 years ago

Yeah and the delay in the code your posted above is wrong (according to what you did in the video). It should be "delay(1000)" not delay(1)

Anonymous user

2 years ago

Very VERY useful. OF course I clicked on this! I want to log data in excel or even move some controls into VBA to pass back down to Ardiunos.

Anonymous user

2 years ago

This project is very great and what I need, but this technique needs arduino board to be attached with computer, I am making biometric attendance project for company, I want all the data to be exported to someone's computer, but they cannot attach their PC to arduino (attendance machine may be outside from office or on main door), so the data must be sent through wifi, can you please giude how can I do that?

m_karim02

2 years ago

You can do this by using Arduino WiFi Module

Anonymous user

5 years ago

Hi i'm testing it right now, it's really helpful. i have a question, i wanted to show to outputs from arduino to excel, i try it but it's puting the two value in one column ... how do we display two value?

Anonymous user

6 years ago

How to add more columns in this? and get more sensor data values?

m_karim02

2 years ago

Hello Please visit my youtube. There have a lot of videos to add more sensor data.

HammasMajeed

7 years ago

This project is very great and what I need, but this technique needs arduino board to be attached with computer, I am making biometric attendance project for company, I want all the data to be exported to someone's computer, but they cannot attach their PC to arduino (attendance machine may be outside from office or on main door), so the data must be sent through wifi, can you please giude how can I do that?

m_karim02

2 years ago

You can do this by using Arduino WiFi Module

mattlogue

7 years ago

Very VERY useful. OF course I clicked on this! I want to log data in excel or even move some controls into VBA to pass back down to Ardiunos.

Anonymous user

7 years ago

i am beginner, in grade 6 school i followed the steps provided and it worked on excel its good thank you

m_karim02

2 years ago

Happy to hear this, You are most welcome

Anonymous user

7 years ago

interesting project, simple but effective. Well done and thanks for sharing

m_karim02

2 years ago

most welcome

Anonymous user

7 years ago

This sketch only ‘measures’ the voltage at pin A0 and prints it. I don’t see a timer. Why the unnecessary and confusing lines 3, 4, 5 and 9?

m_karim02

2 years ago

yes, you can change delay according to your need.

m_karim02

2 years ago

3,4,5,9 lines for the additional serial print. I am very Sorry if it confuse you. I write for the advanced learners.

AKJ

2 years ago

Yeah and the delay in the code your posted above is wrong (according to what you did in the video). It should be "delay(1000)" not delay(1)