How to read a .csv file in matlab?

2013 7 29
1 个回答
回答已采纳
16 次查看（30 天）

0 个投票

my .csv file opens in excel and every row is in the form:
2013 | 094 | 22:57:13 | 2456387.456 | 5.002 | 0.006 | 4.992 | 0.001 | -0.01 | -0.005 | 7.99 | 5 | 2 | 0
| : represents a space (it is not in the .csv file)
I would like to read every numeric value in the file (not including the semi-colon [:] )
thanks in advance,
Cordelle

请先登录，再回答此问题。

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-7-29

0 个投票

8 个评论
显示 6更早的评论 隐藏 6更早的评论

Cordelle
Cordelle 2013-7-29
I did and once the csvread function encountered the colon(:) an error message occured, heres the code
[FileName,FilePath ]= uigetfile(); ExPath1 = fullfile(FilePath, FileName);
c = csvread(ExPath1,5,0);
Cordelle
Cordelle 2013-7-29
The error message that occured:
Error using dlmread (line 139)
Mismatch between file and format string.
Trouble reading number from file (row 1u, field 4u) ==> :57:13, 2456387.456405440, 5.002, 0.006, 4.992, 0.001, -0.010, -0.005, 7.99, 5, 2, 0.000\n
Cordelle
Cordelle 2013-7-29
I tried xlsread and it runs just fine except when reading in the input matlab is reading NaN 0.0000 Nan and etc
Azzi Abdelmalek
Azzi Abdelmalek 2013-7-29
Use
[a,b,c]=xlsread('fic.csv')
Then use the cell array c
Cordelle
Cordelle 2013-7-29
what does a,b,c correspond too?
Azzi Abdelmalek
Azzi Abdelmalek 2013-7-29
a : numeri variable
b: text variable
c: both numeric and text variable
Cordelle
Cordelle 2013-7-29
being that I have three different arguments available, How can I re-write the info back into an excel file with a different name using
xlswrite(someName, argument)

请先登录，再进行评论。

更多回答（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