Import Excel file to MATLAB

2 次查看(过去 30 天)
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?

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2012-9-22
编辑:Azzi Abdelmalek 2012-9-22
[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 个评论
Azzi Abdelmalek
Azzi Abdelmalek 2012-9-23
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 (,)

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by