You need to create the DT variable.
Remove “dt” from the field, so the error goes away.
Then go back to the field, type dt
and press Ctrl+K
… then click variables
tab below the workflow and make sure the dt
variable was created with type datatable
( you can also create it manually if you want )
Then you can use write range
to add the data to excel sheet.
( or select read range
and press F8 to set a breakpoint, then run the workflow. Once the robot gets to read range, it will stop and show the content of all variables in the properties tab. here you can inspect the content of the datatable and validate you got all the information )