Download Data from Excel worksheet: Automatically changing range in Excel
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
BdS
le 18 Mar 2019
Réponse apportée : Alex Mcaulley
le 18 Mar 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 commentaires
Réponse acceptée
Alex Mcaulley
le 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!