Read Excel file / headers in the row

[nina.wenner]

Hi,

I need another tip from you. I would like to read out an Excel file. My result should be that I have a variable with “1111” (Buchungskreis), “Mr Test” (Name) etc.

Thank you and best regards
Nina

[nisarga]

hello,

You can use Excel transposition to read excel row as a column or else u can read the entire excel and do string manipulation to achieve ur requirement.

Thank you

[Pierre_Fleury]

Hello @nina.wenner,

You can use a dictionary to store the name and value of variables.
For each row of the dataTable read in the Excel sheet, add an element to the dictionary (Key = Name, Value = value).

Or you can use a filter on your data table to extract the row that contains the value you are looking for.

[nina.wenner]

Hi @nisarga,

i was able to solve it using excel transpose. thanks for your help.