how to transform data from excel to tesx

Question

Muhsin 2017-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/373621-how-to-transform-data-from-excel-to-tesx

评论： Walter Roberson 2017-12-19

Hello all; Can anyone please help me transform the data from excel to txt in a format like the attached file? Thank you very much

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-12-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/373621-how-to-transform-data-from-excel-to-tesx#answer_296863

在 MATLAB Online 中打开

fid_in = fopen('input.csv', 'rt');
fid_out = fopen('output_file.txt', 'wt');
colname_line = fgetl(fid_in);
colnames = regexp(colname_line, '\s*\t\s*', 'split');
colnames_formatted = sprintf('$#%8s%10s%10s%10s%10s%10s%10s%10s', colnames{:});
empty_formatted = blanks(80);
while true
  thisline = fgetl(fid_in);
  if ~ischar(thisline); break; end    %end of file detected
  vals_in = sscanf(thisline, '%f');
  fprintf(fid_out, '*PART\n$# title\n%s\n%s\n', empty_formatted, colnames_formatted);
  fprintf(fid_out, '%10g%10g%10g%10g%10g%10g%10g%10g\n', vals_in);
end
fclose(fid_in);
fclose(fid_out);

"Bug-for-bug compatible" as they say in the industry...

2 个评论
显示无隐藏无

Muhsin 2017-12-19

input.csv

Dear Walter; I dont know what is wrong with csv format of previous attached file. I have corrected. Can you please new csv file that is attached to this comment?