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