How to write strings and numbers in excel file?

Question

vaggelis papasot 2017-12-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374198-how-to-write-strings-and-numbers-in-excel-file

回答： Walter Roberson 2017-12-22

I want to write data in an excel file. I need the first row to strings/labels of the data e.g f_min, f_max_, loss_1, loss_2. Then the next rows will have the data under the above labels. I use xlswrite but can't find how to append the data to the next rows

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-12-22

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374198-how-to-write-strings-and-numbers-in-excel-file#answer_297421

在 MATLAB Online 中打开

headers = {'f_min', 'f_max', 'loss_1', ...};
data_as_cell = num2cell(YourNumericDataArray);
info_to_write = [headers; data_as_cell];
xlswrite(AppropriateFilename, info_to_write);