Download Data from Excel worksheet: Automatically changing range in Excel
1 view (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
Alex Mcaulley
on 18 Mar 2019
If you don't specify the range the whole file is loaded. Try this:
T=readtable('xxx_Ang_SekUnformated.xlsx','Sheet','Worksheet')
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!