Column names with double quotes

excel
activities

#1

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


#2

@shrganes, You need to escape it.

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

Regards,
Dominic :slight_smile:


#3

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

“”“data”""


#4

thank you :slight_smile: