Excel data to Arduino

[MRSSPOCK]

Hi.

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?

Thanks

 

[IRstuff]

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 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm