Kylewill
❔ Need C# form to write to excel, but automatically filling in the next available empty cells.
I am trying to get text boxes from my Windows Form to write to an excel sheet, but breaking to the next empty row and doing the same thing. I just need Column A-D in each row filled in. with A = tbname.Text, B = tbphone.Text, C = ddisue.Text, D = lbdate.Text. Then breaking to row 2 A-D for the next customers info. The form is a kiosk that lets customers input this info and it resets for the next person. My only problem now is getting this data into excel. The excel sheet is saved to C:\Users\Willi\OneDrive\Desktop\log\form.xlsx
I can write to static cells however it overwrites once I click submit on the form again.
7 replies