Rename/Remove default sheet name as Sheet1

[sbhardwaj8717]

Description
I am trying to looking for some method so that I can rename the default sheet name or I can remove the default sheet named as Sheet1

go version go1.17.6 darwin/amd64

Describe the results you received:

[xuri]

Please rename sheet name with SetSheetName.

[microo8]

And how it can be deleted? I'm creating the sheets in a loop and this is just there. wb.DeleteSheet("Sheet1") doesn't work.
EDIT: ok so it works if there some sheets. So i'll do it at the end, before writing to file.

[sbhardwaj8717]

Thanks @xuri this works fine for me ;)

[sbhardwaj8717]

@xuri I am stuck in resizing the cell width according to the cell data. Is there any way to may it possible to resize the cell size automatically?

[xuri]

This library support setting the text font size fit cell by setting the ShrinkToFit style for cells, but doesn't support set columns width or rows height to fit the cell, also reference issue #92.

[esodell]

I was also wondering about deleting Sheet 1 after creating other named sheets in a loop. Found out you can with DeleteSheet() but only after you've added other sheets, so just append the delete after your loop

[xuri]

Hi @esodell, as the documentation of the DeleteSheet function says: it will be invalid when only one worksheet is left. This behavior was similar to Excel.