error while importing excel file

4 次查看（过去 30 天）

AL 2022-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1873402-error-while-importing-excel-file

评论： AL 2022-12-7

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);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Fangjun Jiang 2022-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1873402-error-while-importing-excel-file#answer_1122687

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 个评论
显示 1更早的评论隐藏 1更早的评论

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.