Excel Read Range not working

Segment 1 : I am using data scraping and storing the order ids in excel using excel application scope and write range

Segment 2: For another application link to use order id i am using read range to get order ids from excel for type into activity however i am getting compilation error for the datatable datatype to ienumberable type error

@Sathish_Ashokan

Please write .ToString at the end in the screenshot

Apart from that for enumerable type…I believe initially you would have used for each insteqd of for each row in datatable

Cheers

.tostring means it is only printting “datatable” not order id in the excel. please help

Hi @Sathish_Ashokan
Try this:

CurrentRow("Orderid").ToString

Hope it helps!!


Still not accepting I need to complete today please help

@Sathish_Ashokan

Use for each row datatable activity instead of for each.

@Sathish_Ashokan

Is there any null values in the order id column?

If yes, use if condition in the for each row datatable to check if the currentitem(“Order Id”).toString
is nothing or not.
Not String.IsNullorWhiteSpace(currentitem("Order Id").toString) or Not String.IsNullorEmpty(currentitem("Order Id").toString)
Then print message box.

Content of excel only 3 order id with no headers

@Sathish_Ashokan

If no headers then you have to call by column index.
CurrentRow(0).ToString

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.