python excel pandas openpyxl_python – 使用Openpyxl与现有工作簿的Pandas Excel Writer

在ExcelWriter的源代码中,使用openpyxl,它初始化空工作簿并删除所有工作表.这就是你需要明确添加它的原因

class _OpenpyxlWriter(ExcelWriter):

engine = 'openpyxl'

supported_extensions = ('.xlsx', '.xlsm')

def __init__(self, path, engine=None, **engine_kwargs):

# Use the openpyxl module as the Excel writer.

from openpyxl.workbook import Workbook

super(_OpenpyxlWriter, self).__init__(path, **engine_kwargs)

# Create workbook object with default optimized_write=True.

self.book = Workbook()

# Openpyxl 1.6.1 adds a dummy sheet. We remove it.

if self.book.worksheets:

try:

self.book.remove(self.book.worksheets[0])

except AttributeError:

# compat

self.book.remove_sheet(self.book.worksheets[0])