[Python] Python Openpyxl: Copy and Paste from one Excel workbook to another - Content

This is my first time of using Openpyxl. So I am trying to copy and paste contents from one Excel workbook to another using the library. The code works fine when I execute it. However, my challenge is that instead of the code to copy the content below the the content already in the workbook, it replaces the content in the workbook. And this is not my objective.

I have tried to look at the tutorial and also do some research, but I could not seem to get what I was doing wrong. Below is the code that I am using

import openpyxl as opxl

#Opening the destination excel file
sourceFile = "C:\\ForTesting\\sourceFile.xlsx"

sourceworkbook = opxl.load_workbook(sourceFile)
sourceworksheet = sourceworkbook.worksheets[0]

#Opening the destination excel file
destinationFile = "C:\\ForTesting\\destinationFile.xlsx"

desinationworkbook = opxl.load_workbook(destinationFile)
destinationworksheet = desinationworkbook.active

# calculate total number of rows and
# columns in source excel file
maximum_row = sourceworksheet.max_row
maximum_column = sourceworksheet.max_column

# copying the cell values from source
# excel file to destination excel file
for i in range (1, maximum_row + 1):
for j in range (1, maximum_column + 1):
#reading the cell value from source excel file
c = sourceworksheet.cell(row = i, column = j)

#writing the value read from the source file to destination file
destinationworksheet.cell(row = i, column = j).value = c.value

#Save the destination excel file
sourceworkbook.save(str(destinationFile))

print("The File has been saved successfully")


I will appreciate it if someone can point me to what I am doing wrong or what I need to do.

Continue reading...