Skip to main content
Solved

read column names in excel

  • February 3, 2023
  • 1 reply
  • 600 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.

View original
Harika
Did this topic help answer your question?

1 reply

Padmakumar
Forum|alt.badge.img+13
  • Padmakumar
  • Navigator | Tier 3
  • 785 replies
  • 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

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings