Download Data from Excel worksheet: Automatically changing range in Excel
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
BdS
am 18 Mär. 2019
Beantwortet: Alex Mcaulley
am 18 Mär. 2019
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 Kommentare
Akzeptierte Antwort
Alex Mcaulley
am 18 Mär. 2019
If you don't specify the range the whole file is loaded. Try this:
T=readtable('xxx_Ang_SekUnformated.xlsx','Sheet','Worksheet')
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!