Python Forum
help with an exercise
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
help with an exercise
#5
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?
Reply


Messages In This Thread
help with an exercise - by iiiik - Aug-21-2023, 02:33 PM
RE: help with an exercise - by jefsummers - Aug-21-2023, 05:33 PM
RE: help with an exercise - by iiiik - Aug-21-2023, 05:46 PM
RE: help with an exercise - by snippsat - Aug-21-2023, 06:16 PM
RE: help with an exercise - by iiiik - Aug-21-2023, 06:45 PM
RE: help with an exercise - by snippsat - Aug-21-2023, 07:15 PM
RE: help with an exercise - by iiiik - Aug-21-2023, 07:40 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020