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

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

Réponses (1)

Azzi Abdelmalek
Azzi Abdelmalek le 2 Avr 2014
Modifié(e) : Azzi Abdelmalek le 2 Avr 2014
You can use xlsread

Cette question est clôturée.

Clôturé :

le 20 Août 2021

Community Treasure Hunt

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

Start Hunting!

Translated by