Import Excel file to MATLAB

2 vues (au cours des 30 derniers jours)
Rodrigo Trigona
Rodrigo Trigona le 22 Sep 2012
I am trying to import a simple excel file for MATLAB but I'm having trouble with it. The file I want to import from excel is like this:
First row -> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Second row -> 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 I'm using the function xlsread but in all possible forms the matlab read the fraction part like a txt file. What is the function can I use to read this file like it is?

Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 22 Sep 2012
Modifié(e) : Azzi Abdelmalek le 22 Sep 2012
[v,T,vT]=xlsread('file.xls')
%v: numeric array class: double
%T: text array class cell
%vT: both numeric and text array class cell
%or
num=xlsread('file.xls') % num is numeric array
  11 commentaires
Rodrigo Trigona
Rodrigo Trigona le 23 Sep 2012
Ok
Azzi Abdelmalek
Azzi Abdelmalek le 23 Sep 2012
I see it's a text because you have dot(.) instead of comma(,)
use this to read your second rows
l2=cellfun(@(x) str2num(x),vT(2,:))
or go to your excel file, find and replace (.) by (,)

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by