Read Range from column A3 to the end of the file

[Giulia_G (Giulia)]

Hi!

I wanna read an Excel file from the column A3 (it’s a static position) until the end of the file (it’s a dynamic archive, i don’t konw where it ends).

I’ve already tried Read Range “A3:” but it didn’t work Help, please!

[sarathi125 (Parthasarathi)]

Hi,

First use a read range with a blank range specified and get the total rows.

Then use another read range with the range as “A3:” + (dataTable.Columns.Count+ 65).ToString + dataTable.Rows.Count.ToString

this will work until you have columns till Z position.

[Palaniyappan (Palaniyappan P)]

@Giulia_G

I’ve already tried Read Range “A3:” but it didn’t work Help, please!

you were almost done buddy
just mention as “A3” (no semicolon)
so that it will start from A3

Cheers @Giulia_G