xlswrite is not recommended, what should I use instead?

6 次查看（过去 30 天）

Gabriela Garcia 2021-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/720614-xlswrite-is-not-recommended-what-should-i-use-instead

评论： Gabriela Garcia 2021-1-19

I have eleven 12x8 matrices composed of 1s and 0s. I want to export each matrix into its own excel file as a table with the rows labeled with times and the columns labeled with weekdays. I want to use an efficient code and possibly a loop to prevent typing over and over again. Each Matrix is saved as as a variable, like 'A53'. Of the eleven matrices, ten are have consecutive counting titles, like 'A51', 'A52', 'A53'...'A60'. Is it possible to use a loop to load these into separate excel sheets, as described above?

2 个评论
显示无隐藏无

Walter Roberson 2021-1-19

8 days a week??

Gabriela Garcia 2021-1-19

7, that was a typo

请先登录，再进行评论。

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

回答（1 个）

Star Strider 2021-1-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/720614-xlswrite-is-not-recommended-what-should-i-use-instead#answer_600914

Since you have R2020a, first, create a table using your data, then use writetable to write it to an Excel file (or other options).

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2021-1-19

Open in which program?

Gabriela Garcia 2021-1-19

While I run the script that is supposed to write the matrices into their own excel sheets, is there another function to add that will have the new excel documents open?

请先登录，再进行评论。

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