Read range : Cannot find column 4

Help Activities
, ,
1

I am trying to read range of excel file (in microsoft office 365 scope) after creating a sheet and appending column names as such

image

when i try to read range with add headers enabled, i get the message : cannot find column 4

if i disable the add headers option, i lose my column names and get “column1, column2…” which is not what i want

this is bizarre, how can i work my way around this ?

thank you

edit: my project is in windows version and the version the 365 package is 2.1.1

2

If possible, please send sample input so that I give a try

3

you mean the workflow ? or the excel file?
thank you

4

please provode ypu input excel

5

sure, here:
test.xlsx (8.7 KB)

my UiPath project is in windows version

6

Hi Adext

Kindly check the attached zip file for your solution. Hope it will work

Excel.zip (2.7 KB)