Effacer les filtres
Effacer les filtres

Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

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

1 vue (au cours des 30 derniers jours)
Warakorn
Warakorn le 2 Avr 2014
Clôturé : MATLAB Answer Bot le 20 Août 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

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.

Community Treasure Hunt

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

Start Hunting!

Translated by