Download Data from Excel worksheet: Automatically changing range in Excel
조회 수: 1 (최근 30일)
이전 댓글 표시
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
채택된 답변
Alex Mcaulley
2019년 3월 18일
If you don't specify the range the whole file is loaded. Try this:
T=readtable('xxx_Ang_SekUnformated.xlsx','Sheet','Worksheet')
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Downloads에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!