Cannot set name to sheets

[JWo1F]

Hi! I want to use custom names for my sheets. But I can't because it need to name "Sheet" + index.
It's critical bug, I think.

https://github.com/Luxurioust/excelize/blob/master/cell.go#L14
https://github.com/Luxurioust/excelize/blob/master/sheet.go#L22
https://github.com/Luxurioust/excelize/blob/master/sheet.go#L35

[JWo1F]

@Luxurioust how to progress?

[xuri]

@JWo1F Thank you very much for your comments. I will commit for this issue as soon as possible.

[xuri]

@JWo1F I have add new function GetSheetIndex() to provides a method to get worksheet index by name. You can also use the GetSheetMap() function to get all sheets index and name map. Why not add set cell value by sheet name support for function SetCellValue() directly or add an new export function? I think that to find the index by worksheet name will use a lot of types of inference internally it will affect performance. Please tell me if there is a better idea.

[luca-moser]

@Luxurioust there is still a bug, the sheet name must be modified after cells were written to it, otherwise the generated excel file is invalid.

[xuri]

@luca-moser Sorry, I don't understand what you mean, could you provide file attachments or some codes?