Download Data from Excel worksheet: Automatically changing range in Excel

1 次查看（过去 30 天）
BdS
BdS 2019-3-18
回答： Alex Mcaulley 2019-3-18
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.

请先登录，再回答此问题。

采纳的回答

Alex Mcaulley
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by