how do i rename or remove a sheet from an excel spreadsheet using matlab

30 views (last 30 days)
When using Matlab "writetable" or "xlswrite" function to create a new Excel file, I always get three worksheets created by default.
I want to delete two unwanted worksheets, and rename the third. Or, I want to be able to set Matlab defaults to only create one worksheet, that I can then rename.
I have Excel installed (MicroSoft Office 365 ProPlus) and configured to create new workbooks with only one sheet.

Answers (1)

xi
xi on 1 May 2017
https://www.mathworks.com/matlabcentral/answers/215703-changing-the-name-of-the-sheet-in-excel

Products

Community Treasure Hunt

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

Start Hunting!