擅长:python、mysql、java
<p>这段代码不是很好,并且有多个错误。例如,在CreateWorkbook中,创建工作簿,然后保存它。但是,在CreateSheet中,实际上不需要重新打开该文件。每次保存后都必须重新打开该文件。以下是我修复这些错误的方法:</p>
<pre class="lang-python prettyprint-override"><code>import openpyxl
def CreateWorkbook(workbook_path):
workbook = openpyxl.Workbook()
workbook.save(workbook_path)
return workbook_path
def CreateSheet(workbook, sheet_name):
wb = openpyxl.load_workbook(workbook)
wb.create_sheet(sheet_name)
wb.save(workbook)
return sheet_name
def WriteCell(workbook, sheet_name, cell, cell_data):
wb = openpyxl.load_workbook(workbook)
worksheet = wb[sheet_name]
worksheet[cell] = cell_data
wb.save(workbook)
return
workbook = CreateWorkbook('workbook1.xlsx')
sheet = CreateSheet(workbook, 'Sheet1')
WriteCell(workbook, sheet, 'A1', 'testing')
</code></pre>
<p>我希望这对你有用</p>