Read Range from column A3 to the end of the file

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 :frowning: Help, please!

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.

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

Cheers @Giulia_G

1 Like

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