MATLAB Answers

How to name an excel worksheet when using writetable

277 views (last 30 days)
Stephen
Stephen on 21 Jul 2017
Commented: Seum Bin Rahman on 11 Oct 2019

Is there a simple way to name an the excel worksheet when using the writetable fnx? I am aware of the answer by Thomas Koelen on 8 May 2015 (https://www.mathworks.com/matlabcentral/answers/215703-changing-the-name-of-the-sheet-in-excel) but I am hoping there is a more direct and simple method, not involving ActiveX. Instead of an excel workbook with "Sheet1", "Sheet2", etc I want to give specific names to the worksheets.

Accepted Answer

Fangjun Jiang
Fangjun Jiang on 21 Jul 2017
writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')
  6 Comments
Seum Bin Rahman
Seum Bin Rahman on 11 Oct 2019
https://www.mathworks.com/matlabcentral/answers/92449-how-can-i-delete-the-default-sheets-sheet1-sheet2-and-sheet3-in-excel-when-i-use-xlswrite

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!