필터 지우기
필터 지우기

How do I write excel sheetnames in 2019a?

조회 수: 3 (최근 30일)
george hargenrader
george hargenrader 2020년 5월 2일
댓글: 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
Tommy 2020년 5월 2일
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')
or
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?
Steven Lord
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.)

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by