Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel data to Arduino

Excel data to Arduino

Excel data to Arduino


Does anyone know if there is a way to send data from an Excel sheet column, either directly or indirectly via a text file, to the Arduino (Atmega328P) ?

At the minute I use Excel to generate a column of numbers, which I then copy and paste into my Arduino code array definition.

I would like to be able to somehow be able to manage to do this without actually firing up the IDE, even although it is installed.

(I realise it might need fired up, but even if this could happen invisibly would be fine. I don't even mind if this has to take place at a command prompt, via something like a .BAT batch file).

My reason is that I want someone with no Arduino IDE knowledge at all, to simply be able to open the relevant Excel file, where all cells are locked, apart from those driving parameter cells which the user is permitted to alter.

Once the user has made their parameter adjustments, I want them then to be able to run a simple exe, batch file or similar, which will transfer the data from the Excel column, into the relevant sketch's array definition, then load the resulting sketch into the 328P

I can find lots of examples of Arduino to Excel, but not the inverse.

If anyone knows of such a project, a link to this would be appreciated.

Maybe there is a totally different way to achieve this?


RE: Excel data to Arduino

So, it doesn't sound particularly real-time. I've not done this specific thing myself, but you could have an auto-run VBA that creates the numbers writes the data directly into the array definition file. VBA has the ability to open text files and move around in them.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now
The Great Project Profitability Debate
A/E firms have a great opportunity to lead the world into the future, but the industry’s greatest asset—real-time data—is sitting wasted in clunky, archaic ERP platforms. Learn how real-time, fully interactive dashboards in a modern ERP allow you to unlock data that will shape the future of the world. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close