Openpyxl是用于读取和写入Excel(扩展名为xlsx / xlsm / xltx / xltm)文件的Python库。openpyxl模块允许Python程序读取和修改Excel文件。
例如，用户可能必须遍历数千行并挑选一些信息，才能根据某些条件进行较小的更改。使用Openpyxl模块，可以非常有效且轻松地完成这些任务。
示例# import openpyxl module
import openpyxl
#Call a Workbook() func of openpyxl to create a new blank Workbook object
wb = openpyxl.Workbook()
# Get workbook active sheet from the active attribute
sheet = wb.active
# Cell objects also have row, column and coordinate attributes that provide
# location information for the cell.
# The first row or column integer is 1, not 0. Cell object is created by
# using sheet object's cell() method.
c1 = sheet.cell(row = 1, column = 1)
# writing values to cells
c1.value = "Vishesh"
c2 = sheet.cell(row= 1 , column = 2)
c2.value = "Ved"
#Once have a Worksheet object,one can access a cell object by its name also
# A2 means column = 1 & row = 2.
c3 = sheet['A2']
c3.value = "Python"
# B2 means column = 2 & row = 2.
c4 = sheet['B2']
c4.value = "Programming"
#Anytime you modify the Workbook object or its sheets and cells, the #spreadsheet file will not be saved until you call the #save()workbook method.
wb.save("C:\\Users\\Vishesh\\Desktop\\demo.xlsx")