Moonset1995的博客

import pandas as pd import numpy as np from openpyxl import load_workbook book = load_workbook(r'C:\Users\zhimin.liu\Desktop\数据存储test.xlsx') try: ws = book["insert_test"] book.remove(ws) #删除需要替换的sheet except: print('无需删除的shee.

数字格式转化 仅大于0的时候 [>=100000000]0!.00,“亿”;[>=10000]0!.0,“万”;#,##0 有大于0也有小于0的时候【万级别】 [红色][<=-10000]-0!.0,“万”;[>=10000]0!.0,“万”;#,##0 有大于0也有小于0的时候【亿级别】 [红色][<=-100000000]-0!.00,“亿”;[>=100000000]0!.00,“亿”;0!.0,“万” ...