Immediate Panel getting all columns from my excel sheet

Help Studio
, ,
1

I want to grab all the names of the columns from the immediate panel from my excel sheet. What function would I use?

2

@xspunky,

Read excel file with Read Range activity
Use this expression in immediate panel

yourdatatabl.Columns

This will print all the columns of your excel in the immediate panel.

3 Likes
3

Ah I didn’t declare my variable for my workbook so the datatable.columns wasn’t working for me. thank you so much. I was just trying to use just currentrow(0) and not the actual column name so I was getting frustrated. Thank you.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.