Use variables for DataRange option in detectImportOptions
6 次查看(过去 30 天)
显示 更早的评论
So,
I'm reading an xlsx file with
covidData = detectImportOptions('COVID19.xlsx');
now, I would like to use
covidData.DataRange = 'firstIndex:lastIndex';
to access the data I need. Problem is that my range is saved into variables and, I don't think that .DataRange took actual variable as a range but it works only if I use actual number as
covidData.DataRange = '1:2';
Is there a way to bypass it?
0 个评论
采纳的回答
更多回答(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!