Download Data from Excel worksheet: Automatically changing range in Excel

Hi

I will have to download data from excel worksheets on a daily bases. I used the following formula:

T=readtable('xxx_Ang_SekUnformated.xlsx','Sheet','Worksheet','range','A1:AG276')

It works good. But everyday the range of data in excel changes; it gets bigger. Do you know a formula which first checks the range of data in excel and inserts it in the above mentioned formula, so that I am sure that I will take all columns and rows of data from the excel file to matlab?

thanks a lot for your help.

Answer 1

[Alex Mcaulley]

If you don't specify the range the whole file is loaded. Try this:

T=readtable('xxx_Ang_SekUnformated.xlsx','Sheet','Worksheet')