Need To Skip First Row and Read The Headers

Hi

I want to read age column which will starts from 2row.

In that age column sometimes we may get 10 data sometimes 100data.

How we can get the values from age column. Attached screenshot below.

image

Thanks,
Rishi

@Putta_Sri_Sai_Rishik_Chow

In read range activity if you give range as A2 then it would read till end of the data in excel

Excel.Sheet("Sheet1").Range("A2")

Cheers

It was not working with google spreadsheets using gsuite activties :frowning:

@Putta_Sri_Sai_Rishik_Chow

Did you try that ideally it would reall whole of the spreadsheet starting from given cell

Even i fyou give A1 is it not reading?

Cheers

@Putta_Sri_Sai_Rishik_Chow

Use Read Range in the Gsuite SpreadSheet section

There you can place Range as “A2”

Hope this may help you

Thanks,
Srini

you use use delete row activity to delete the first row, then you could read range using the headers