xlwings设置单元格格式为文本-改正身份证显示问题+excel单元格设置为文本为何还要双击

关键代码 sht.range("a:a").api.NumberFormat = "@"

import xlwings
wb = xlwings.Book()
sht = wb.sheets['sheet1']

try:
    sht.range('a:a').api.font.size = 15  # 设置单元格字体大小
    sht.range("a:a").api.font.name = "微软雅黑"  # 设置字体
    sht.range("a:a").api.NumberFormat = "@"
    sht.range('A1').value = '350821199408302712'
    sht.range('A2').value = '350821199408302712'
    sht.range('B1').value = '350821199408302712'
    sht.autofit()
    wb.save('666')
    wb.close()
except Exception:
    wb.close()

如果是先设置单元格格式为文本再写入数字就不会出现双击正常显示