In the documentation on “Read Range” for Excel it is stated that “If the range isn’t specified, the whole spreadsheet is read.” But what does “the whole spreadsheet mean?”
I have a spreadsheet with 877 rows (see picture). My BOT must find the last empty row, which is 878, and paste some data there. There are some empty rows above this last one, as you can see. Some of the cells have formulas in them, and this formulas are auto-filled down to row 2000 or so.
When I do a read range (with blanks in the range) it is bringing back many more rows than 877, and then there is an append range with a data table and the data is pushed way down the spreadsheet. So this makes me question what read range considers the “rest of the worksheet”. Can’t be where there is no data at all because there are no rows with no data sprinkled throughout the sheet. Do formulas / formatting count?
The read range had “preserve formatting” checked previously. This slows things down, and I don’t think I care about formatting, but maybe this is essential to get the right number of rows?
Any help would be appreciated.