txt处理成excel

样式：

添加筛选： https://openpyxl-chinese-docs.readthedocs.io/zh_CN/latest/filters.html

?

1 2 3

writer = pd.ExcelWriter(file_s) writer.sheets[sheet_n].freeze_panes = 'A2'  # 冻结表头 writer.sheets[sheet_n].auto_filter.ref = "A1:Z2" # 添加筛选

　　

冻结

?

1 2 3

#https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html?highlight=freeze_panes   this_df.to_excel(writer, sheet_n, index=False, freeze_panes=(1, 1))

　　

识别文件编码：

?

1 2 3 4 5 6 7 8 9 10 11

import chardet    # 获取文件编码类型 def get_encoding(file):     # 二进制方式读取，获取字节数据，检测类型     with open(file, 'rb') as f:         return chardet.detect(f.read())['encoding']       file_name = 'my.ini' encoding = get_encoding(file_name)this_df = pd.read_csv(file, delimiter="\t", encoding=encoding )<em id="__mceDel">this_df.to_excel(writer, sheet_n, index=False)</em>