CODEWITHSUNDEEP
excelmatlab
user3217416
user3217416

Reputation: 37

xlsread error MATLAB

I am loading an excel file into MATLAB. I need only select values.

A1=xlsread('freq1.xls','B2:B4')

But the command window outputs the whole column with a warning: Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP XLSREAD for more information.

In xlsread at 176 In bkh at 1 Warning: Range cannot be used in 'basic' mode. The entire sheet will be loaded. In xlsread at 184 In bkh at 1

How can I get the specific values?

Upvotes: 1

Views: 2241

Answers (1)

Dan
Dan

Reputation: 45752

According to the docs you can't read a specific range in 'basic' mode and if you do not have Excel installed on your computer then it defaults to 'basic' mode. So I guess your options are either install Excel, or read in the entire page and select your range from the resulting Matlab matrix rather than from the Excel sheet.

Upvotes: 4

Related Questions