Excel Read Column

After completing the workflow below, it writes system.object, but it needs to write the columns. ??

The Read column activity reads the single column into an IEnumerable.

This is a collection of each row.

To display the whole collection you can use

String.join(“,”,column)

To access the header row you can use column(0).ToString

1 Like

Hi, This is not what I’m looking for. Isn’t there an event called just get column in uipath? I just want to take column B and print it to column C, that’s all. can you describe a little bit?

Hi @d.ulutas,

You can reach the column name by using the dt you read and the index.

dt.Columns(0).ToString

If you want to list all columns follow the below path.Put the table you are reading in a loop (dt.Columns) and manage all the columns in it.

image

Regards,
MY

what should i do if i want to list only column c?

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