How can I read in data from Excel where I have the row range stored as a variable

1 次查看(过去 30 天)
I am reading data from an excel sheet, and can read my data perfectly fine when I define the row range as a number, such as:
LPHYB = xlsread('Tungurahua_Activity_Log_temp.xlsx', ...
'Hourly_Seismic_Record', 'G699:G1004');
However, I would like to be able to store my first row and last row as a variable, like this:
LPHYB = xlsread('Tungurahua_Activity_Log_temp.xlsx', ...
'Hourly_Seismic_Record', 'Gstartrow:Gendrow');
This is not working. The error message reads:
'Maximum variable size allowed by the program is exceeded.'

采纳的回答

Jan
Jan 2017-1-31
编辑:Jan 2017-1-31
Matlab's error message is not clear. You can define the string as following:
LPHYB = xlsread('Tungurahua_Activity_Log_temp.xlsx', ...
'Hourly_Seismic_Record', sprintf('G%d:G%d', startrow, endrow));

更多回答(0 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by