I can use the following line
opts = detectImportOptions(workbookFile,’Sheet’,sheetName,’Range’,Range);
containing an excel range name (see name manager) in Range and the corresponding sheet name in sheetName. The thing is, excel already allows me to set range names for the whole workbook. So, no need to specify the sheet name. I’d like my script to be agnostic to changes in sheet names or positions.
How can I do that?
If I launch without sheetName
opts = detectImportOptions(workbookFile,’Range’,Range);
Matlab doesn’t find my range, although the range name in excel is given with "Scope: Workbook".I can use the following line
opts = detectImportOptions(workbookFile,’Sheet’,sheetName,’Range’,Range);
containing an excel range name (see name manager) in Range and the corresponding sheet name in sheetName. The thing is, excel already allows me to set range names for the whole workbook. So, no need to specify the sheet name. I’d like my script to be agnostic to changes in sheet names or positions.
How can I do that?
If I launch without sheetName
opts = detectImportOptions(workbookFile,’Range’,Range);
Matlab doesn’t find my range, although the range name in excel is given with "Scope: Workbook". I can use the following line
opts = detectImportOptions(workbookFile,’Sheet’,sheetName,’Range’,Range);
containing an excel range name (see name manager) in Range and the corresponding sheet name in sheetName. The thing is, excel already allows me to set range names for the whole workbook. So, no need to specify the sheet name. I’d like my script to be agnostic to changes in sheet names or positions.
How can I do that?
If I launch without sheetName
opts = detectImportOptions(workbookFile,’Range’,Range);
Matlab doesn’t find my range, although the range name in excel is given with "Scope: Workbook". excel MATLAB Answers — New Questions

​