Copy whole worksheet with openpyxl

Solution 1:

Version 2.4 will allow you to do this: copy_worksheet

>>> source = wb.active
>>> target = wb.copy_worksheet(source)

For older ones you can probably copy the source code from here

UPDATE: You can't simply graft this code into older versions of the library

Solution 2:

You can't do this easily. The best approach is probably the one described in bug 171