I have a question regarding some best practices in terms of reading excel files with the axll library. Here, we have to specify the header / dataranges before reading. Often, we don't know exactly how many rows of data we have. We can of course set the max row number arbitrary large (or to the excel sheet row limit of 1,048,576), but that feels like a ‘dirty’ solution.
Is there another way we can only read the rows which actually have data? Ideally, I would like some sort of functionality which ‘peeks’ into the file and tells us where the data is.
Curious to hear possibilities in this regard. Thanks!
Best answer by Richard StegemanView original