Simple Workbook save to new name corrupts 3D charts
Created originally on Bitbucket by Larry Weisberg
Refer to the thread and sample code and excel input file at https://groups.google.com/forum/#!topic/openpyxl-users/Kanyg9UrC3k
Basically, if an excel has a 3D chart and you load and then save with a new name - and then repeat, saving the first copy to a 3rd excel - the last excel opens corrupted. The basic code is the following, where ifilename and ofilename differ.
wb_in = load_workbook(filename=ifilename) wb_in.save(ofilename) wb_in.close()