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

조회 수: 1(최근 30일)
Luke Marsden
Luke Marsden 2017년 1월 31일
편집: Jan 2017년 1월 31일
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 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