How to give names to the sheets using xlswrite?
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Image Analyst
am 5 Apr. 2021
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 Kommentare
Image Analyst
am 6 Apr. 2021
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.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!