sanitize excel sheet name
We need to sanitize excel sheet names otherwise an error is thrown:
https://www.excelcodex.com/2012/06/worksheets-naming-conventions/
- The name must be unique within a single workbook.
- A worksheet name cannot exceed 31 characters.
- You can use all alphanumeric characters but not the following special characters:
\ , / , * , ? , : , [ , ]
I ran into this problem when writing an excel file with marker_genes.get_rank_genes_tables
but this will occur for all excel outputs. So writing a small sanitize function is probably the best option.