清空筛选条件
清空筛选条件

How to write to csv with full display of date format

12 次查看（过去 30 天）
Kanakaiah Jakkula
Kanakaiah Jakkula 2016-3-19
编辑： Kanakaiah Jakkula 2016-3-19
Hi, I have the following data,and I want to write to csv as it is (i mean date also with full display).
a={'name1' '2016/3/18 20:24:45.678' '23'}
I use the following command,
xlswrite('outputData.csv',a)
But I lose the date format (display), I am getting the following output in csv file:
name1 24:45.7 23
How to retain the date dispaly (2016/3/18 20:24:45.678, not as 24:45.7). Please help some one.
Sincerely, Mekala

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

回答（1 个）

Jan
Jan 2016-3-19
It works as expected under Matlab 2015b and Office 2010, so I guess your file is okay, but you display it in Excel, which has the power to show dates with smart filters.
But note, that the created file is not a CSV file, but an Excel file. If you want a CSV file, using csvwrite or dlmwrite will fail also, because they do not treat the cell string correctly.
Therefore a hard coding might be useful:
fid = fopen(FileName, 'w');
if fid == -1, error('Cannot open file for writing: %s', FileName); end
fprintf('%s,%s,%s\n', a{:});
fclose(fid);
  4 个评论
显示 2更早的评论
Stephen23
Stephen23 2016-3-19
Or avoid cd and the bad habits that it allows, by using pwd:
fullfile(pwd,...)
Kanakaiah Jakkula
Kanakaiah Jakkula 2016-3-19
编辑：Kanakaiah Jakkula 2016-3-19
Sir,
How can I write to ".xlsx" file, Because that is my main issue, I want to write to ".xlsx" and retain the date dispaly. Sincerely,

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by