When you do an ExportData from Excel the column names of the data table need to exactly match what the lookup table column names are. I usually set CreateHeader to true which causes the columns to be named using the header row values and then I set the names of the columns in the lookup table accordingly.
Another thing that can cause a problem is that the key field in the data table created using ExportData may not be unique.
Check the logs to see what exception you are getting to determine what the real issue is.
Posted: 4 years ago
Posted: 3 Jan 2018 3:07 EST
Selvakumar Shanmugakkani (Selvaactz)
Manager - RPA