error while importing excel file

6 次查看（过去 30 天）
AL
AL 2022-12-7
评论： 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);

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2022-12-7
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更早的评论
Fangjun Jiang
Fangjun Jiang 2022-12-7
  1. Specify the sheet by number or name directly, e.g. xlsread(file, 2), xlsread(file,'sheet2')
  2. 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
AL 2022-12-7
Thank you so much, now it is working.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by