python - Excel 文件损坏或扩展名错误错误 openpyxl & writerxlsx

Question

我正在使用以下代码创建 excel 文件并使用 xlsxwriter 和 openpyxl 对其进行编辑，因为稍后我可能需要从其他 excel 文件中读取，但是当我尝试打开该文件时它给我一个错误excel 文件已损坏或扩展名不正确。当源文件保存为 .xlsm 时，此错误不存在，我想知道为什么会这样。

import xlsxwriter
import openpyxl

# Create a workbook and add a worksheet.
workbook = xlsxwriter.Workbook('Dabble dabble.xlsx')
worksheet = workbook.add_worksheet()

workbook.close()

target_file = 'Dabble dabble.xlsx'
i = 2


No = i - 1
Company = "Panasonic"
Location = "California"
Store_type = "Hyper Market"
Date = "1/1/2020"



No_loc = "A" + str(i)
company_loc = "C" + str(i)
location_loc = "B" + str(i)
store_type_loc = "D" + str(i)
date_loc = "E" + str(i)


srcfile = openpyxl.load_workbook(target_file, read_only=False,
                                             keep_vba=True)



sheetname = srcfile['Sheet1']

sheetname[No_loc] = No
sheetname[company_loc] = Company
sheetname[location_loc] = Location
sheetname[store_type_loc] = Store_type
sheetname[date_loc] = Date


# Table headers
sheetname["B1"] = "Location"
sheetname["C1"] = "Company"
sheetname["D1"] = "Store Type"
sheetname["E1"] = "Date"


i = i + 1
srcfile.save(target_file) #Saving data to file
import pandas as pd

target_file = "Dabble dabble.xlsx"

df= pd.read_excel(target_file)

print (df)

但是，当我使用 pandas 解析文件时，它会读取数据，这表明文件已创建并写入。

  Unnamed: 0    Location    Company    Store Type      Date
0           1  California  Panasonic  Hyper Market  1/1/2020

Answer 1

问题是您正在设置 keep_vba=True 但您正在处理的文件不是 xlsm 文件并且没有 vbaProject 文件。只需将其设置为 false 或省略该选项即可。

srcfile = openpyxl.load_workbook(target_file, 
                                 read_only=False,
                                 keep_vba=False)