# Excel Data Entry
# pip install openpyxl
from openpyxl import Workbook
from openpyxl.styles import *
# Set up workbook
book = Workbook("excel.xlsx")
pyexcel = book.active
# Set up header
pyexcel.append(["Name", "Job Desc", "Salary"])
# Write by rows
pyexcel.append(["John", "JS Programmer", "$100,000"])
pyexcel.append(["Jane", "Py Programmer", "$150,000"])
# Write by columns
pyexcel["A1"] = "John"
pyexcel["B1"] = "JS Programmer"
pyexcel["C1"] = "$100,000"
# Write by cell
pyexcel.cell(row=1, column=1).value = "John"
pyexcel.cell(row=1, column=2).value = "JS Programmer"
# Format cell
pyexcel.cell(row=1, column=1).font = Font(bold=True)
# save workbook
book.save("excel.xlsx")