Read Excel and Show Data in Datatables - Doesnt show anything

I am trying to read data from the excel (attached in zip). the code runs successfully but doesn’t show anything in the output. Attached screenshot


Read Excel.zip (19.6 KB)

You are asking the loop to output only the column with the Index 1

row.Item(1).ToString

And it does, CompanyName.

It works as directed. If you want to see all the details in that column, remove the break so the loop finishes.

1 Like

Hi,
The outputdatatable activity will convert the datatable to string and you can use write line or message box to se the datatable in the form of string.

let us know if this helps.
Regards,
Pavan H

1 Like

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