# Copy Excel Sheet to another Using Python openpyxl module
import openpyxl as xl
path1 = 'C:/Users/gary/file1.xlsx'
path2 = 'D:/C:/Users/gary/file2.xlsx'
wb1 = xl.load_workbook(filename = path1)
ws1 = wb1.worksheets[0]
wb2 = xl.load_workbook(filename = path2)
ws2 = wb3.create_sheet(ws1.title)
for row in ws1:
for cell in row:
ws2[cell.coordinate].value = cell.value
wb2.save(path2)
沒有留言:
張貼留言