saving in a specific text file format

3 次查看（过去 30 天）
soe thiha
soe thiha 2019-10-28
评论： dpb 2019-10-29
Dear Matlab users
I am preparing a text file. I have an excel file (A.xlsx) with two columns.
25.000 10.000
26.000 9.000
......... ..........
I want to save a text file with the following format(first number,second number with three decimal).
25.000,10.000
26.000,9.000
I tried the code like this. But, the output result comes out with zigzag and not a separated files. So, how can I save the data and please help me. Thank you very much.
clear all;clc
A= xlsread('A.xlsx');
A1=A(:,1);
A2=A(:,2);
fileID = fopen('output.txt','w');
fprintf(fileID,'%2.3f,%2.3f\n',A1,A2);
fclose(fileID);

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

回答（1 个）

dpb
dpb 2019-10-28
>> fmt='%8.3f,%8.3f\n'
fmt =
'%8.3f,%8.3f\n'
>> fprintf(fmt,A.')
25.000, 10.000
26.000, 9.000
>>
  4 个评论
显示 2更早的评论
soe thiha
soe thiha 2019-10-29
dear walter thank you for your comments.
dpb
dpb 2019-10-29
You can minimize the number of blanks by setting the width of the field to the minimum needed for the largest value in the array but you can't eliminate entirely unless all values are within the same order of magnitude (hence have same number of digits).

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by