How to open .CSV file ?

3 次查看（过去 30 天）
Vishnu Dhakad
Vishnu Dhakad 2018-6-13
回答： Walter Roberson 2018-6-15
I want to open CSV file. (please find the attachment)
in the CSV file, I have date and time in the different column but I want to combine in one column. I have read with following code but I getting an error.
fbc = fopen('ABCD.CSV');
BC = textscan(fbc, '"%.f-%3.s-%.f", "%.f:%.f", %.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f');
fclose(fbc);

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

回答（2 个）

KSSV
KSSV 2018-6-13
[num,txt,raw] = xlsread('ABCD.csv') ;
  1 个评论
Vishnu Dhakad
Vishnu Dhakad 2018-6-15
编辑：Vishnu Dhakad 2018-6-15
Thank you, sir
but time is showing in decimal, how to correct into normal?
I want to use the function fopen and textscan.
Can you explain to me how to use this type of function?

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2018-6-15
fmt = ['%{dd-MMM-yy}D%{HH:mm}D', repmat('%f', 1, 50)];
fbc = fopen('ABCD.CSV', 'r', 'n', 'UTF8');
BC = textscan(fbc, fmt, 'Delimiter', ',', 'CollectOutput', 1);
fclose(fbc);
dt = BC{1}+(BC{2}-dateshift(BC{2},'start','day'));
dt.Format = 'default';
numbers = BC{3};

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by