Aug-21-2023, 02:33 PM
I wanted to ask you about an exercise that tries to combine two columns in different excel sheets from python, that compares row by row if they are equal or not and if they are, print a 1 and if they are not equal a 0.
import openpyxl from openpyxl.styles import PatternFill datafile1 = openpyxl.load_workbook("C:\\Users\\ime1s\\Downloads\\MiCalculo.xlsx") fill_style = PatternFill(start_color="FDD835", end_color="FDD835", fill_type="solid") data_sheet1 = datafile1["Calculo"] data_sheet2 = datafile1["Calculo2"] for i in data_sheet1.iter_rows(): for cell in i: current_cell_value = cell.value cell_location = cell.coordinate if current_cell_value != data_sheet2[cell_location].value: cell.fill = fill_style datafile1.save("compared_file.xlsx")That's ok?
import openpyxl from openpyxl.styles import PatternFill datafile1 = openpyxl.load_workbook('test1.xlsx') fill_style1 = PatternFill(start_color='FDD835', end_color='FDD835', fill_type='solid') fill_style2 = PatternFill(start_color='cc0000', end_color='cc0000', fill_type='solid') data_sheet1 = datafile1['Sheet1'] data_sheet2 = datafile1['Sheet2'] # Create a new sheet for comparison results comparison_sheet = datafile1.create_sheet('Comparison Results') # Iterate through rows in both sheets and compare values for row1, row2 in zip( data_sheet1.iter_rows(min_row=1, max_row=data_sheet1.max_row), data_sheet2.iter_rows(min_row=1, max_row=data_sheet2.max_row), ): for cell1, cell2 in zip(row1, row2): if cell1.value == cell2.value: comparison_sheet.cell(row=cell1.row, column=cell1.column, value=1).fill = fill_style1 else: comparison_sheet.cell(row=cell1.row, column=cell1.column, value=0).fill = fill_style2 datafile1.save('compared_file.xlsx')