Filter löschen
Filter löschen

Info

Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.

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

1 Ansicht (letzte 30 Tage)
Warakorn
Warakorn am 2 Apr. 2014
Geschlossen: MATLAB Answer Bot am 20 Aug. 2021
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
You can use xlsread

Diese Frage ist geschlossen.

Community Treasure Hunt

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

Start Hunting!

Translated by