Skip to main content
Answer

read column names in excel

  • February 3, 2023
  • 1 reply
  • 709 views
H
Forum|alt.badge.img+4

how to read column names in excel, where the position/index of column name changes for each file

Best answer by Padmakumar

Hi @Harika 1170 ,

 

While opening the excel with Excel: Open action, uncheck the box “Sheet contains header”. This will include the Column headers as well while looping. So, the 0 index will be assigned to the Column header.

Harika

1 reply

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • Answer
  • February 3, 2023

Hi @Harika 1170 ,

 

While opening the excel with Excel: Open action, uncheck the box “Sheet contains header”. This will include the Column headers as well while looping. So, the 0 index will be assigned to the Column header.

Padmakumar
Terms & ConditionsCookie settingsAccessibility statement