Excel sheet(office 365 Excel - online) read range returns “Read Range: Column names or order do not match ”

Help Studio
, ,
1

Hi Everyone,

I have data on Excel sheet(office 365 Excel - online) sheets on one drive.
I am trying to extract data from one drive workbook sheets into a data table using read range activity but i keep getting this weird error that the column names do not match. I have no idea where the reference is coming from. I have even resorted to.

image
image801×457 72.1 KB

Error log :- Read Range: Column names or order do not match. Individual errors: at index 0: expected: ID but got name, at index 1: expected: name but got ID

Regards,
Vivek

2

@vparihar1

Try removing thw activity and add back…

Also if you remove read header is it working?

Cheers