Column names with double quotes

How can i select the column name in the ‘get row item’ activity if the column name has double quotes in them

@shrganes, You need to escape it.

Try this example: dt.Rows(0)(""“Column0"”").ToString.

Dominic :slight_smile:

Hi @shrganes

First Use Read Range and store the data in Data Table - lets say DT_IN

Second , Use For each activity and give the DT_IN as Data Table

Then , Use get row item activity specify the Data Table row as Row.

Finally in the Property Pane , click on the Column Name and add as per below.

If the Column Name = “data” in your excel file ,

Just paste the below as it is in Column Name Property Window


thank you :slight_smile: