User Profile

Fatman003 started a topic Copy data from different workbook into Master sheet using Python

in Python

Aug 27 '19, 07:32 AM
Copy data from different workbook into Master sheet using Python
I have to copy data from different workbooks and paste it into a master workbook. All the workbooks including the Master file are located in a folder: C:\Users\f65651 \data

So far I have been able to copy data from only one workbook using the code below

Code:

import openpyxl as xl path1 ='C:\\Users\\f65651\data\\cq1.xlsx' #One of the doc #path3 = 'C:\\Users\\f65651\data\\cq2.xlsx' path2='C:\\Users\\f65651\\data\\Results.xlsx'

...
See more | Go to post

Fatman003 replied to Thread Modes Python code to copy data from multiple workbooks into master sheet

Aug 21 '19, 06:03 AM

So far I have done this:

Code:

import openpyxl as xl

path1="C:\Users\f6565\Desktop\data\data1.xlsx"
path2="C:\Users\f6565\Desktop\data\Result.xlsx"

wb1 = xl.load_workbook(filename=path1)
ws1 = wb1.worksheets[0]
wbX = xl.load_workbook(filename=path0)
wsX = wbX.worksheets[0]
wb2= xl.load_workbook(filename=path2)
ws2= wb2.worksheets[0]

...

See more | Go to post

Last edited by gits; Aug 21 '19, 07:31 AM. Reason: please use code tags

Profile Sidebar

Copy data from different workbook into Master sheet using Python

Leave a comment:

Thread Modes Python code to copy data from multiple workbooks into master sheet