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

Answer 1

[Fangjun Jiang]

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)

[AL]

i have two different excel workbook, in which one contains only 1 sheet while otherone has 2 sheets.

while importing the workbench if i dont specify the sheet name it is giving me above error and if i mention sheet(1) in code then it is worrking for workbook which has only one sheet; however, for workbook 2. the main data is on sheet 2 and i want to import that sheet.

is there any way i can make it user define to enter whcih sheet he wants?

regards,

AL

[Fangjun Jiang]

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]

Thank you so much, now it is working.