fprintf not writing same information from command window
2 次查看(过去 30 天)
显示 更早的评论
I want to create two columns. The first column has numbers 1 through 10 from f. The second column has zeros from b, but in certain positions contained in a there needs to be values. Some of the values are duplicates so that is taken care of with the accumarray. I need the zeros to be in the format 0.0 and the numbers have 9 decimal places. When I type out in the command window it had the correct numbers in the correct places but the zeros and number formats are incorrect, but in the xlsreadtrial.txt file it doesn't look correct.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/191261/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/191262/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/191263/image.png)
b=zeros(10,1);
% writes zeros
a = xlsread('trial.xlsx','Sheet2','A1:B4');
% reads values from excel
f = (1:1:10)';
% first column values
h=a(:,1);
% breaks a into first column only
n=a(:,2);
% breaks a into second column only
k=[f;h];
% adds first column of a onto the end of f
m=[b;n];
% adds second column of a onto the end of b
p=[k,m];
% combines first and second columns
c = 9 * ones(length(p),1);
c(b==0) = 1;
out=[unique(p(:,1)) accumarray(p(:,1),p(:,2))];
% makes first column values unique and accounts for duplicates
fileID = fopen('xlsreadtrial.txt','w');
fprintf(fileID,'%d,%.f\n',out');
fclose(fileID);
4 个评论
Walter Roberson
2018-6-14
Didn't we already deal with this at https://www.mathworks.com/matlabcentral/answers/404005-fprintf-varying-number-of-decimal-places-in-a-column#answer_323200 ?
回答(1 个)
Jonathon Gibson
2018-6-14
编辑:Jonathon Gibson
2018-6-14
If you want different formatting depending on the row, you can print each row individually:
fileID = fopen('xlsreadtrial.txt','w');
for row = out'
if row(2) == 0
fprintf(fileID,'%d,%.1f\n',row);
else
fprintf(fileID,'%d,%.9f\n',row);
end
end
fclose(fileID);
Which gives you 9 decimal places if the second column is not equal to 0 and just 1 decimal place for the 0s.
1,0.368945000
2,0.0
3,0.598764523
4,0.0
5,0.500000000
6,0.0
7,0.0
8,0.0
9,0.0
10,0.0
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!