Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ENGLISH: https://neculaifantanaru.com/en/how-to-import-data-from-one-excel-file-to-another-excel-file-with-python.html
- -------------------
- import openpyxl #open the bookstore I want to work with
- wb_AAA = openpyxl.load_workbook("AAA.xlsx") #open the file in which I import the data
- ws_1 = wb_AAA['Date_angajati'] #define the sheet I work with
- wb_UI = openpyxl.load_workbook("ttestui.xlsx") #open the file from which I import the data
- ws_2 = wb_UI['UI']
- sh_obj = wb_UI.active
- max_row = sh_obj.max_row
- # loop will print all values
- # of column1, 2, 4, etc
- code2name = {}
- for i in range(2, max_row+1):
- cell_obj = sh_obj.cell(row=i, column = 4)
- # print(cell_obj.value) displays the data in column 4 wb testUI
- code2name[sh_obj.cell(row=i, column=1).value]=(sh_obj.cell(row=i, column=4).value, sh_obj.cell(row=i, column=5).value) #associate the search value (vlookup excel) with the definitions in the testUI
- print(code2name)
- for i in range (2, ws_1.max_row):
- print(i)
- """
- associate the columns where I import data with the value by which I search for them (vlookup)
- get is the equivalent of "iferror"
- ('','') ...if iferror('value', ''), displays error, in the sense that it searches for the first character out of nothing
- [0][1] refers to line 19, the values after =
- """
- ws_1.cell(row=i, column=7).value = code2name.get(ws_1.cell(row=i, column=6).value, ('',''))[0]
- ws_1.cell(row=i, column=10).value = code2name.get(ws_1.cell(row=i, column=6).value, ('',''))[1]
- wb_AAA.save('BBB.xlsx')
Add Comment
Please, Sign In to add comment