openpyxl.writer.excel module

Write a .xlsx file.

class openpyxl.writer.excel.ExcelWriter(workbook, archive)

基类：object

Write a workbook object to an Excel file.

save()

Write data into the archive.

write_data()

Write the various xml files into the zip archive.

write_worksheet(ws)

openpyxl.writer.excel.save_virtual_workbook(workbook)

Return an in-memory workbook, suitable for a Django response.

注解

Deprecated: Use a NamedTemporaryFile

openpyxl.writer.excel.save_workbook(workbook, filename)

Save the given workbook on the filesystem under the name filename.

参数

• workbook (openpyxl.workbook.Workbook) – the workbook to save

• filename (string) – the path to which save the workbook

返回类型

bool