python - AttributeError：“工作簿”对象没有属性“add_format”

Question

下面是我的代码，我正在合并〜分隔文件并将它们保存为 xlsx 格式但出现错误

align_format = workbook.add_format() AttributeError: 'Workbook' 对象没有属性 'add_format'

我正在使用 Python 3.6.8

from pandas import ExcelWriter
import os
import sys
import glob
import pandas as pd
import openpyxl


def testfunc(target_filename):
table_list = []

for filename in glob.glob("E:\\dev\\Python_Dev\\Python368\\*.dat"):
    print(filename)
    table_list.append(filename)

writer = ExcelWriter(target_filename, engine=None)

for sheet in table_list:
    (_, f_name) = os.path.split(sheet)
    (f_short_name, _) = os.path.splitext(f_name)
    df = pd.read_csv(sheet, delimiter='~', encoding='unicode_escape')
    df.to_excel(writer, sheet_name=f_short_name, index=False)

    workbook = writer.book
    worksheet = writer.sheets[f_short_name]
    align_format = workbook.add_format()
    align_format.set_align('center')

writer.save()
writer.close()

if __name__ == "__main__":
   test_func(sys.argv[1])

标签： python

Answer 1

pip install xlsxwriter

解决了这个问题。