error while importing excel file
显示 更早的评论
I am trying to import an excel file into matlab environment; however, excel file contains two sheets. I want to import only one sheet whichever user imports.
[filename,pathname,~]=uigetfile('.xlsx'); %select the excel file
sheets = sheetnames(filename);
[~, ~, raw] = xlsread([pathname filename],sheets);
Error using xlsread
Sheet argument must be a string scalar, a character vector, or an integer.
Error in importfile (line 4)
[~, ~, raw] = xlsread([pathname filename],sheets);
采纳的回答
Fangjun Jiang
2022-12-7
0 个投票
Run the code line by line, check the value of some variables and you will find the problem easily.
[~, ~, raw] = xlsread([pathname filename],sheets);
should use fullfile(pathname,filename) to compose the full file name
sheets is a string array. You will probably need to use sheets(1)
3 个评论
AL
2022-12-7
Fangjun Jiang
2022-12-7
- Specify the sheet by number or name directly, e.g. xlsread(file, 2), xlsread(file,'sheet2')
- get the sheet names by using sheets=sheetnames(), and then compare "sheets" with the known name to find the index. This would be the most generic and robust approach.
AL
2022-12-7
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
