My excel file:
Error message:
Hi not sure why the Lookup Data table wasnt able to read the columnName… Please helps. Thanks
My excel file:
In read range if you leave it empty it read from the first available cell which is title …so the column names are not Revision etc
instead give the range as the cell number of Revision(I guess "A7") so that the data is read only from revision column value
Hope this helps
cheers
It’s likely that the column name “Revision” needs to be amended to whatever UiPath was able to read from the Excel sheet. You could try inspecting the column headers of the dtData variable to see what are its headers. Either write dtData out into a temporary Excel, or use a breakpoint to pause the execution after reading the Excel.
Hi @monicaong0609 ,
Thanks for reaching out to UiPath community.
Insert log messages or breakpoints in your workflow to examine the values of variables and arguments. This will help you identify any incorrect values or inconsistencies causing the error.
Regards,
@pratik.maskar