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

1 view (last 30 days)
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.'

Accepted Answer

Jan
Jan on 31 Jan 2017
Edited: Jan on 31 Jan 2017
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));

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!