how to use excel data in matlab?
显示 更早的评论
I know I can use
num = xlsread(filename, sheet, range)
to get data from excel file.
But my project will get more data as time goes on.
So I need to know how I can adjust my range as more data to be upload for matlab.
for instance at month 1 my data would be 3 5 7 and I should upload these data to get mean value. and month 2 data would be 3 5 7 9 11 and I should upload all these data to get mean value.
Can I do this in matlab?
采纳的回答
Image Analyst
2012-11-25
Either leave out range altogether to get everything, or set the range to a specific range with sprintf():
range = sprintf('R%dC%d', rowNumber, columnNumber);
num = xlsread(filename, sheet, range);
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
