An error is reported when writing the specified cell. When the following two sentences are executed
name_format = workbook.add_format({'font_color': '#0000FF'})
worksheet.write('k1', os.path.basename(gtk_agile_bom_path), name_format)
worksheet.write('k1', os.path.basename(gtk_agile_bom_path), name_format) File "E:\Gerrit_Project\pyenv\bomflyenv\lib\site-packages\xlsxwriter\worksheet.py", line 82, in cell_wrapper new_args = xl_cell_to_rowcol(first_arg) File "E:\Gerrit_Project\pyenv\bomflyenv\lib\site-packages\xlsxwriter\utility.py", line 126, in xl_cell_to_rowcol col_str = match.group(2) AttributeError: 'NoneType' object has no attribute 'group'
Solution:
I found that k1,k lowercase can not be written, change it to the upper case: K1, and then run it OK
worksheet.write('K1', os.path.basename(gtk_agile_bom_path), name_format)