Import Excel file to MATLAB

2012 9 22
1 个回答
回答已采纳
6 次查看（30 天）

0 个投票

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

0 个投票

[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 个评论
显示 9更早的评论 隐藏 9更早的评论

Rodrigo Trigona
Rodrigo Trigona 2012-9-23
How can i make the program read the 'T' like a numeric array?
Rodrigo Trigona
Rodrigo Trigona 2012-9-23
I need both rows read as a numeric array but this function read as a numeric and text
Azzi Abdelmalek
Azzi Abdelmalek 2012-9-23
what do you mean?
Rodrigo Trigona
Rodrigo Trigona 2012-9-23
this function read only the first row as a numeric array and the second row as a text array. I need the first and second row read as numeric.
Azzi Abdelmalek
Azzi Abdelmalek 2012-9-23
How is the second rows in your file numeric or text? can you post these two rows?
Rodrigo Trigona
Rodrigo Trigona 2012-9-23
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
Azzi Abdelmalek
Azzi Abdelmalek 2012-9-23
编辑：Azzi Abdelmalek 2012-9-23
can you upload your file
Azzi Abdelmalek
Azzi Abdelmalek 2012-9-23
subscript i needed to download, email me your file
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by