How could I get the last value of a column header in Excel based on the filled data?

Hi @pprin001,
I am unclear with the question, are you trying to read the entire sheet into a data table, in which case you don’t need to provide any range

If you want to get the count of either the last row or column, then use the datatable_variable.RowCount or datatable_variable.ColumnCount properties.

Let me know if this solves your issue

Thanks,
Nishant