Write string and table (in that order) to text file

Question

Melissa Buechlein 2020-7-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/564290-write-string-and-table-in-that-order-to-text-file

回答： Melissa Buechlein 2020-7-13

I need to write a string and a table to one text file. The string contains a description of the data in the table, but is not the headers for the table. I am using R2019a which I guess means the "Append" writetable option does not work? Please see my example data below:

% Load data
load cereal.mat;
table =  table(Calories, Carbo, Cups, Fat, Fiber, Mfg, Name, Potass);
string = {'This is a string about the cereal table'};
filename = "dummyoutput.sfc";
% How I tried to do this (which does not work!)
fid = fopen(filename, 'w', 'n');
fprintf(fid, '%s', cell2mat(string))
fclose(fid);
writetable(table, filename, 'FileType', 'text', 'WriteVariableNames', 0, 'Delimiter', 'tab', 'WriteMode', 'Append')

I get this error (because 'WriteMode' was introduced in R2020a)

Error using writetable (line 155)
Wrong number of arguments.

Does anyone have a workaround for this?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

Melissa Buechlein 2020-7-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/564290-write-string-and-table-in-that-order-to-text-file#answer_465167

在 MATLAB Online 中打开

I doubt this is the most efficent workaround, but it solved my issue.

writetable(table, filename, 'WriteVariableNames', 0,...
    'FileType', 'text', 'Delimiter', 'space', 'QuoteStrings', false)
content = fileread(filename);
 % Update the file
 content = {cell2mat(header{:}); content};
 
 % go back and remove empty lines
newcontent = regexprep(content, {'\r', '\n\n+'}, {'', '\n'});
 % write the full file
 writecell(newcontent, filename, 'FileType', 'text', 'QuoteStrings', false);

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

请先登录，再进行评论。

Answer 2

Takumi 2020-7-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/564290-write-string-and-table-in-that-order-to-text-file#answer_465158

编辑：Takumi 2020-7-13

How about using this function?

https://www.mathworks.com/matlabcentral/fileexchange/28600-xlsappend

4 个评论
显示 2更早的评论隐藏 2更早的评论

Takumi 2020-7-13

编辑：Takumi 2020-7-13

How about writing in fprintf instead of writetable?

Append To or Overwrite Existing Text Files

table2array

table2cell

Melissa Buechlein 2020-7-13

My output table is not all of the same format, so I cannot turn it into an array. I am also unfamiliar with how to make fprintf work with cells. However, I was able to come up with a work around! Thanks for your suggestions!

请先登录，再进行评论。