Is there a way to write data to excel, on different sheets, with each sheet named?

Question

Teshan Rezel 2021-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/869703-is-there-a-way-to-write-data-to-excel-on-different-sheets-with-each-sheet-named

回答： Vivek 2023-8-4

Hi folks,

I am trying to write data from matlab into excel, onto multiple sheets within the same excel file. However, I would like each new sheet to be renamed to a specific string which I define.

As far as I can tell, this is not an option in an existing matlab function. Is there a way around this please?

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

请先登录，再进行评论。

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

Answer 1

Sam 2021-7-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/869703-is-there-a-way-to-write-data-to-excel-on-different-sheets-with-each-sheet-named#answer_737573

编辑：Sam 2021-7-1

In the writetable/writematrix/writecell method, you can specify the name of the sheet you want to write the data to. If given sheet does not exist, it will be created. Refer to this link for more information.

Note: if a new sheet is added, matlab will throw a warning. The link above also contains information about how to supress such warnings.