Writing a file with columns

Question

X 2011-7-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/11367-writing-a-file-with-columns

Hello, I have a matrix 1000x3, and I want to write that data into a .csv file. The problem I have is that when I open the new file, I have the matrix that I wanted in one column. I want to have 3 columns when I open the excel file (Say A, B, C). Does anyone knows if it is possible to write my data in three separate columns? Thank you

fid = fopen('16.csv','w'); %Opens the file
fprintf(fid, '%5.2f\v %5.2f\v %d\v \n', T_DB, T_DP, RH);
fclose(fid); %Closes the file

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Oleg Komarov 2011-7-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/11367-writing-a-file-with-columns#answer_15494

在 MATLAB Online 中打开

EDIT

T_DB = rand(1,10);
T_DP = rand(1,10);
RH   = 1:10;
fid = fopen('16.csv','w'); %Opens the file
fprintf(fid, '%5.2f,%5.2f,%d\r\n', [T_DB; T_DP; RH]);
fclose(fid);