create_safe_sheet_name method

create_safe_sheet_name

Checks given sheet name and create a valid one when needed. If given sheet name conforms to the rules of excel sheet name, then return it. Otherwise string will be truncated if length exceeds the limit and invalid characters will be replaced with ’ ‘, then return the rebuilt string value.

Returns

def create_safe_sheet_name(self, name_proposal):
    ...
ParameterTypeDescription
name_proposalstrsheet name to be used

create_safe_sheet_name

Checks given sheet name and create a valid one when needed. If given sheet name conforms to the rules of excel sheet name, then return it. Otherwise string will be truncated if length exceeds the limit and invalid characters will be replaced with given character, then return the rebuilt string value.

Returns

def create_safe_sheet_name(self, name_proposal, replace_char):
    ...
ParameterTypeDescription
name_proposalstrsheet name to be used
replace_charcharcharacter which will be used to replace invalid characters in given sheet name

See Also