openpyxl.writer.excel module

Write a .xlsx file.

class openpyxl.writer.excel.ExcelWriter(workbook, archive)[source]

Bases: object

Write a workbook object to an Excel file.

save()[source]

Write data into the archive.

write_data()[source]

Write the various xml files into the zip archive.

write_worksheet(ws)[source]
openpyxl.writer.excel.save_virtual_workbook(workbook)[source]

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

Note

Deprecated: Use a NamedTemporaryFile

openpyxl.writer.excel.save_workbook(workbook, filename)[source]

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

Parameters:
  • workbook (openpyxl.workbook.Workbook) – the workbook to save
  • filename (string) – the path to which save the workbook
Return type:

bool