Will
Will

Reputation: 315

Add indexed sheets to Excel workbook w/out Openpyxl?

Working with Python 2.7 and I'd like to add new sheets to a current Excel workbook indexed to a specific position. I know Openpyxl's create_sheet command will allow me to specify an index for a new sheet within an existing workbook, but there's a catch: Openpyxl will delete charts from an existing Excel workbook if opened & saved. And my workbook has charts that I don't wish to be deleted.

Is there another way I can open this workbook, create a a few blank sheets that are located precisely after the existing first sheet, all without deleting any of the workbook's charts?

Upvotes: 0

Views: 84

Answers (1)

Charlie Clark
Charlie Clark

Reputation: 19537

openpyxl 2.5 includes read support for charts

Upvotes: 0

Related Questions