❔ 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.
4 Replies
What are you using for writing to excel? EPP?
I am open to that and or interop. I literally havent made progress on either.
But yes i have epp installed and can use that
I suggest you give it a try before asking for help.
but I can give a hint:
worksheet.Dimensions.End.Row is an interesting property 🙂Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.