3

when I try to write data into an already existing excel Sheet, then the existing charts and pie charts in that excel sheet disappears.

Any code to do that via python is appreciated.

Thanks in Advance :)

Abhishake Gupta
  • 2,939
  • 1
  • 25
  • 34

1 Answers1

0

This isn't currently possible using openpyxl (as of 2016-11-22), and based on my googling I don't think it's possible using anything else either, though I could be wrong.

Here is the bug for openpyxl. It is scheduled to be fixed in version 2.5 (they're currently on 2.4)

There's already some code written to read charts, I'm not sure if it works yet though. More info at the link.

Davidjb
  • 1,190
  • 1
  • 12
  • 19