Write data into an excel file "only one time"

[Alexb91]

Hi, I’d like to write selected data to an Excel file.

I want to write the data only when I press a button, so I created a case structure with a button that triggers the write action.

However, since this is in a for loop, the data gets written multiple times by the time I finish pressing the button.

How can I ensure the data is written only once?

One solution might be to increase the loop time so I have time to release the button, but is there another way to achieve this?

[GerdW · Accepted solution]

Hi Alex,

---

@Alexb91 wrote:

However, since this is in a for loop, the data gets written multiple times by the time I finish pressing the button.

How can I ensure the data is written only once?

---

Set the button to a latching "Mechanical action" mode.

Learn about the different possible "Mechanical action" modes for buttons and their use cases!

[Alexb91]

Thank you very much for your help!

I just saw a solution you wrote for someone in 2006, almost 20 years ago.

I don't know how many of us would have managed without your precious help.

I wish you all the best.