How to store various cols in excel in a variable and use those variable names to write out record rows

[Yomi_Oluwadara (darkNight)]

I have an excel sheet with columns headers.

I have a use case to

• create a variable name for each column ( that means 4 variables - 1 per column)
• read the data for each column
  *Using the variables names, write out each record row to a text file. For example
  
  

attached is the excel file.
Book1.xlsx (8.7 KB)

my current workflow does not seem to cut it.

[Anil_G (Anil Gorthi)]

@Yomi_Oluwadara

Ideally you can do that using for each row in excel or can read whole data and then use for each row in datatable

inside the loop use currentRow("ColumnName").ToString to get the data and assign to variable as you need

cheers

[Yomi_Oluwadara (darkNight)]

@Anil_G

currentRow("ColumnName").ToString

@Anil_G attached is my workflow- I was UNABLE to create those variables and use them to write to text
excel.zip (9.9 KB)