xlsx writer在打开excel时导致错误

Question

我目前正在使用xlsx writer将信息从纯文本文件传输到excel。但是，excel文档创建后，大多数时间我无法打开它。我得到以下错误： “很抱歉，Excel遇到错误，无法正常工作。因此需要关闭Excel。在

你想让我们现在修理吗？”在

然后当我选择“立即修复”时，它只会关闭Excel。有时它会工作，我可以查看文件。在

以下是纯文本文件供参考：

"DOT_NUMBER","LEGAL_NAME","DBA_NAME","CARRIER_OPERATION","HM_FLAG","PC_FLAG","PHY_STREET","PHY_CITY","PHY_STATE","PHY_ZIP","PHY_COUNTRY","MAILING_STREET","MAILING_CITY","MAILING_STATE","MAILING_ZIP","MAILING_COUNTRY","TELEPHONE","FAX","EMAIL_ADDRESS","MCS150_DATE","MCS150_MILEAGE","MCS150_MILEAGE_YEAR","ADD_DATE","OIC_STATE","NBR_POWER_UNIT","DRIVER_TOTAL"
10000,"POWELL DISTRIBUTING CO INC","","A","N","N","9125 N BURRAGE AVE","PORTLAND","OR","97217-6961","US","P O BOX 17160","PORTLAND","OR","97217-0160","US","(503) 289-5558","(503) 735-0100","","06-DEC-16","20000","2015","01-JUN-74","OR","1","1"
1000002,"NEW JERSEY BOOM & ERECTORS INC","","A","N","N","120 SANS DRIVE","HENRYVILLE","PA","18332","US","120 SANS DRIVE","HENRYVILLE","PA","18332","US","(570) 620-1546","(570) 620-1517","GAIL@NJBOOM.COM","06-JAN-16","243647","2015","22-JAN-02","PA","1","1"
1000004,"RAY TRUCKING LLC","","C","N","N","218 PEACHTREE ST","WARWICK","GA","31796","US","PO BOX 281","WARWICK","GA","31796","US","(229) 535-4140","","MONTOYARAY@YMAIL.COM","19-OCT-16","83000","2015","22-JAN-02","GA","2","2"
1000008,"GUERRERA LANDSCAPING LLC","","C","N","N","164 NUT PLAINS RD","GUILFORD","CT","06437-2138","US","164 NUT PLAINS RD","GUILFORD","CT","06437-2138","US","(203) 453-6693","","","25-MAR-06","30000","2005","22-JAN-02","CT","4","3"
1000009,"REINHARD CORP","","C","N","N","1647 REINHARD RD","CHESHIRE","CT","06410","US","1647 REINHARD RD","CHESHIRE","CT","06410","US","(203) 272-2869","","","11-APR-06","2000","2005","22-JAN-02","CT","1","1"
1000010,"DELUXE MOTOR COMPANY INC","DELUXE HARLEY DAVIDSON-BUELL","A","N","N","3300 CONESTOGA DR","CASPER","WY","82718","US","3300 CONESTOGA DR","GILLETTE","WY","82718","US","(307) 687-2001","(307) 687-0245","JACKJR59@GMAIL.COM","26-OCT-16","50000","2014","22-JAN-02","WY","8","3"
1000012,"CENTRAL HEATING & AIR INC","","C","N","N","600 S CHARLOTTE","SIOUX FALLS","SD","57103-2614","US","600 S CHARLOTTE","SIOUX FALLS","SD","57103-2614","US","(605) 371-3076","(605) 339-4409","CENTRALHEATING@MIDCONETWORK.COM","26-OCT-10","89918","2008","22-JAN-02","SD","9","5"
1000593,"SIGNAL GATES INC","","B","N","N","1800 S 5TH AVE","TUCSON","AZ","85713-5713","US","1800 S 5TH AVE","TUCSON","AZ","85713-5713","US","(520) 628-3199","(520) 628-3620","KIM@SIGNALGATES.COM","01-NOV-13","100000","2013","24-JAN-02","AZ","7","9"

以及代码（更新）：

^{pr2}$

Answer 1

我看不出你的问题。我通过删除main()和running循环稍微简化了您的程序，并将row增量移到if语句中。具体如下：

import xlsxwriter

filename = "minitest.txt"
file = open(filename, 'r')
print("file opened")

workbook = xlsxwriter.Workbook("Carriers.xlsx")
worksheetA = workbook.add_worksheet()

row = 0
for line in file:
    line = line.replace('"', ' ')
    entry = line.split(",")
    col = 0
    if entry[3] == " A ":
        print(entry[3])
        for item in entry:
            print(row, "|", col)
            print(item)
            worksheetA.write(row, col, item)
            col += 1

        row += 1

workbook.close()
file.close()

然后，我用示例文本文件运行它，它会在没有警告的情况下生成预期的输出：

更新：我运行了更新的程序，也没有发现任何问题：