How to use importfile when there is only one data in cell A1?

Question

Warakorn 2014-4-2

关闭： MATLAB Answer Bot 2021-8-20

I have an excel file named "Test1.xlsx" and there is only one data in cell A1.

I found the error messages when I use the following command

>> a = importfile('Test1.xlsx',1)

??? Error using ==> cellfun Input #2 expected to be a cell array, was char instead.

Error in ==> importfile at 33 data(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),data)) = {''};

When I add one more data to cell A2, this command works fine

>> a = importfile('Test1.xlsx',1)

Do you know how to use "importfile" when there is only one data in cell A1?

Thank you very much,

OOO

此问题已关闭。

Answer 1

Azzi Abdelmalek 2014-4-2

编辑：Azzi Abdelmalek 2014-4-2

You can use xlsread