How to name an excel worksheet when using writetable

2017 7 21
1 个回答
回答已采纳
更新时间：2022 7 9
41 次查看（30 天）

2 个投票

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.

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

 采纳的回答

Fangjun Jiang
Fangjun Jiang 2017-7-21

1 个投票

writetable(TableObj,'test.xlsx','FileType','spreadsheet','Sheet','MyTable')

8 个评论
显示 6更早的评论 隐藏 6更早的评论

Stephen
Stephen 2017-7-21
编辑：Walter Roberson 2022-7-9
Thanks, Fangjun Jiang! Worked great with one caveat: I modified your script slightly to (note the quotation marks):
writetable(TableObj,'test.xlsx','FileType','Sheet',"MyTable")
This indeed names the worksheet, but it ADDS this sheet to an excel workbook such that I now have sheet1, sheet2, and then "MyTable".
Is there a way to get prevent the appearance of sheets 1 and 2...it just is messy. Of course I can delete them in Excel, but I'm looking for a streamlined way of creating the excel workbook.
Fangjun Jiang
Fangjun Jiang 2017-7-21
编辑：Fangjun Jiang 2017-7-21
I can't think of anything if you don't want to involve ActiveX. One last resort yet not ideal is that you create a template Excel file ahead of time. This template Excel file only contains one sheet which you can put some useful notes and comments. Write to this template Excel file by creating a new sheet every time. Or, you can even over-write this one pre-existing sheet.
Stephen
Stephen 2017-7-21
Got it. Thanks. I'm set now. I appreciate your help!
Aleksandra Bucka
Aleksandra Bucka 2018-11-15
Hi Stephen, did you solve your problem with 3 additional empty Excel sheets? Could you explain me how you did it exactly? I would really appreciate it!
Bong Jae Jun
Bong Jae Jun 2019-7-16
The code allows writing data on the specified, named tab. However, it pushed the tab to the last tab and leaving Sheet 1, Sheet 2, and Sheet 3 in front of the data tab created. This is a problem for later use of collecting data. I could not find any way to delete Sheet 1, Sheet 2, Sheet 3 either. Did anyone solve this issue?
Walter Roberson
Walter Roberson 2022-7-9
Hastyar Barvar comments to @Seum Bin Rahman
irreverent and sensing for a downlink
Walter Roberson
Walter Roberson 2022-7-9
Hastyar Barvar:
The topic of the link is how to get rid of the default three sheets that are created, 'sheet1', 'sheet2', 'sheet3' . Deleting those sheets after creation is a valid approach to the question of how to end up with an Excel worksheet that does not have sheets with those names, which is what @Stephen was asking about.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by