How to give names to the sheets using xlswrite?

Question

Riya 2021-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/793212-how-to-give-names-to-the-sheets-using-xlswrite

评论： Image Analyst 2021-4-6

I have written some file names using xls write. Not I have to name those sheets.i have a worksheet..in which there are 3 sheets and i want to name all those sheets.for example, where sheet1 is written..i want to write "duplicatefilesheet".in place of sheet2 i want to write "missing file sheet". In place of sheet3 i want to write "copyfilesheet".how can i do that..?please give some code

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/793212-how-to-give-names-to-the-sheets-using-xlswrite#answer_667562

Did you look at the documentation? The sheet name is the 3rd input argument to xlswrite().

It's best to name them as you write them but if you forgot to and now need to rename lots of sheets, one way is to read them all in again and then write them out with the correct name. Another way is to use ActiveX but it's more complicated.

2 个评论
显示无隐藏无

Riya 2021-4-6

Hi.... I tried the third input arguement. But what happening there is one extra blank sheet is coming as sheet 1. and after that the sheets that i am naming are coming. How can I remove that extra sheet?

and is there any way that i could give sheet number alongwith sheet name.

Image Analyst 2021-4-6

Excel_utils.m

Yes, two ways.

Perhaps you can go into your Excel settings and tell it to start with 0 sheets open. If not,...
You can use the DeleteEmptySheets() function in the attached class if you're using Windows.

请先登录，再进行评论。