Trying to get Excel to update when physical button is pressed

Using Arduino Interfacing w/ Software on the Computer
1

Hello!

I have an idea for a project, but I'm not quite sure where to start. I've done research and haven't been able to find anything yet.

I am trying to get an Excel sheet to update when a button is pressed. I need a date/time column and a count column. Basically, each time a product is finished, this button should get pressed and then a new line in Excel should be created. From this, a Power BI report is updated. The Excel to Power BI is working fine, I'm just trying to get the button to Excel to work. I know there is a way to get things to write to Excel from Arduino, but from what I've found, it's been sensor readings, not a count of something.

Any input/guidance would be appreciated. TIA

2

A sensor reading is no different to a count. They are both just numbers

What does Data Streaming do in Excel ? I have never used it but I know that it exists

3

@abbieh2001, as your topic seems to be more related to "interfacing with a PC", it has been moved to a more appropriate section.

Where is that button? On an Excel form or on the Arduino? For the latter, have a look at PLX-DAQ version 2 - now with 64 bit support! (and further new features).

4

You can write add-ins for applications in the Microsoft Office suite with C#, VB and JavaScript. That should definitely be able to do what you want. Whether there's an easier way I don't know.

5

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