Read Range: Cannot find Column 1

[juanr]

I have a process that uses a microsoft 365 read range activity to read a sharepoint excel sheet. It has been running perfectly for two months but now I start getting this error: “Read Range: Cannot find column 1.”

This is the spreadsheet:

This is my activity:

I have doublechecked all the names of the accounts, the file, and the spreadsheet. Nothing has changed.

I have come accross similar errors and I have fixed them by deleting the read range activity and readding it without changing any of the code. But that cannot be the solution. Any ideas?

I also want to keep my headers

[bhavesh.choubey]

Try making has header false then re check also try to copy the data if excel into another excel and delete the data and then paste the data into that same excel.

Cheers

[juanr]

That did not work unfortunatley, I also need to include the headers. Im getting the same cannot find column 1 error for some reason.

[ashokkarale]

@juanr,

Try deleting empty columns on the right side of your data and empty rows below the data manually once.

There could be possibility that the empty cells are being read as the data.

[bhavesh.choubey]

Check if there any row other that your actual datarow has space in that or not. Also select the empty columns after your last column and press the delete button if there will be any empty column with space the the read range reads that column.

Cheers