How do I write excel sheetnames in 2019a?

4 次查看（过去 30 天）

george hargenrader 2020-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/522360-how-do-i-write-excel-sheetnames-in-2019a

评论： Steven Lord 2020-5-2

The command "sheetnames" was implemented in 2019b. I have 2019a. How do I write the sheetnames of an excel file?

The documentation on the website is great for the most current version of MATLAB. It would be nice if there was a link to the legacy method for those with older versions.

2 个评论
显示无隐藏无

Tommy 2020-5-2

在 MATLAB Online 中打开

Apologies, I must have misread the question at first, although as far as I can tell, sheetnames doesn't let you write sheet names...

You can always specify the name of the sheet when writing to Excel with either xlswrite or writetable / writematrix / writecell / etc... For example

xlswrite(filename, data, 'sheet name')

writetable(T, filename, 'Sheet', 'sheet name')

If you want to change the names of existing sheets, and you're on Windows, maybe this will help?

https://stackoverflow.com/a/9839864

Steven Lord 2020-5-2

FYI at the top of the right frame on the main documentation page is a link to "Other Releases". That allows you to access documentation from the last several releases (back to release R2013a at this time.)

请先登录，再进行评论。

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