• Read an Excel file into a Python DataFrame:
  “`
  import openpyxl

wb = openpyxl.load_workbook(‘my_excel_file.xlsx’)
sheet = wb.active

df = sheet.values
“`

• Write a Python DataFrame to an Excel file:
  “`
  import openpyxl

df = pd.DataFrame({‘A’: [1, 2, 3], ‘B’: [4, 5, 6]})

wb = openpyxl.Workbook()
sheet = wb.active

sheet.append(df)

wb.save(‘my_new_excel_file.xlsx’)
“`

• Manipulate Excel data:
  “`
  import openpyxl

wb = openpyxl.load_workbook(‘my_excel_file.xlsx’)
sheet = wb.active

Change the value in cell A1 to 100

sheet.cell(row=1, column=1).value = 100

Save the changes

wb.save(‘my_excel_file.xlsx’)
“`

openpyxl is a powerful tool for working with Excel data in Python. It is easy to use and has a wide range of features.