I am trying to add a row to an existing excel sheet. The sheet has 1 column called queue-
It should be very simple.
I “read range” the sheet(using add headers is disabled)- output table is “CurrentQueue”
Assign a rowcount ( Item = CurrentQueue.Rows.Count)
Write cell to the next row (range = “A”+(item+1).ToString)
but if I have 0 rows in in my sheet - I get “item = 1”
if I have 1 row in my table I get “item = 1”
Why does read range read the table differently depending on row number?