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

Antworten (1)

Azzi Abdelmalek
Azzi Abdelmalek am 2 Apr. 2014
Bearbeitet: Azzi Abdelmalek am 2 Apr. 2014

0 Stimmen

You can use xlsread

Diese Frage ist geschlossen.

Gefragt:

am 2 Apr. 2014

Geschlossen:

am 20 Aug. 2021

Community Treasure Hunt

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

Start Hunting!

Translated by