want to add worksheet from one workbook in to another workbook using openpyxl

Question

I am pretty sure there is an easier way than how i am doing it, I just have two workbooks and a single sheet in each work book,

does anyone have any any suggestions?

import openpyxl as xl
 
path1 = 'C:\\Users\\path\\test1.xlsx'  path2 ='C:\\Users\\path\\test2.xlsx'
 
wb1 = xl.load_workbook(filename=path1) ws1 = wb1.worksheets[0]
 
wb2 = xl.load_workbook(filename=path2) ws2 =
wb2.create_sheet(ws1.title)
 
for row in ws1:
    for cell in row:
        ws2[cell.coordinate].value = cell.value
 
wb2.save(path2)

The above code works for me, however it does not copy the format. just the cell values. I need formatting of the reports to be the same.

Possible duplicate of [Copy worksheet from one workbook to another one using Openpyxl](https://stackoverflow.com/questions/42344041/copy-worksheet-from-one-workbook-to-another-one-using-openpyxl) — Charlie Clark, Sep 23 '19 at 16:45

eladgl · Answer 1 · 2019-09-23T18:10:25.160

-1

Here:

from openpyxl import load_workbook
from openpyxl import Workbook
wb = load_workbook(path)
ws = wb.active
wb2 = Workbook() #or load_workbook
ws2 = wb2.active
ws2 = ws

Edit:

Above doesn’t copy anything, this link shows how Copy whole worksheet with openpyxl

edited Sep 23 '19 at 18:10

answered Sep 23 '19 at 13:31

eladgl

69
8

This doesn't copy anything. – Charlie Clark Sep 23 '19 at 16:46
You are right, tried it right now. Check this link, https://stackoverflow.com/questions/27101024/copy-whole-worksheet-with-openpyxl – eladgl Sep 23 '19 at 18:09
This doesn't copy anything, its just replacing worksheet that too within same workbook. – Abhishek Kumar Apr 11 '23 at 09:49

want to add worksheet from one workbook in to another workbook using openpyxl

1 Answers1