I’m trying to look up the employee number of a list of companies (list is in excel), and trying to extract the number and write it into a new column on the excel document. I keep receiving the following error: Write DataTable to Excel: The source data has no rows or columns. I have included screenshots of my sequence. Any help would be greatly appreciated!!
Before writing the data table to excel check if the table is getting extracted .
Keep a message box after Extract Table Data activity and verify if the count is equal to the table extracted by below condition:
If the row count is 0 then your table isn’t getting extracted.
Check and update.
Hope it helps!!
In the Extract wizard, what do you see when you click Preview?
Obviously the datatable isn’t being populated so you have to figure out why.
Welcome to community
1.try to check the value of extracteddatatable
Place a message box orl og message and
2.can please place the write range workbook activity outside of for each row in datatable
Hope this helps
Here you take read range activity does not give any datatable variable
Instead of for each excel row you read the data to the datatable right then take for each row in datatable
Thank you so much for the feedback! Please see my questions below:
- Where should I insert the following information? In the For Each Excel Row table or the Write DataTable to excel table? Sorry i’m very new to RPA so the more detail you can provide the better.
Can you provide the value in the read range
The value in the read range is the company name “Google”
You are using for each excel row
Before that you need to
Create a variable for the output of read range excel
This is to be used in type into activity
In the destination field of write datatable to excel activity
And read range can be removed
Hope this helps