Openpyxl是用于读取和写入Excel(扩展名为xlsx / xlsm / xltx / xltm)文件的Python库。openpyxl模块允许Python程序读取和修改Excel文件。
例如,用户可能必须遍历数千行并挑选一些信息,才能根据某些条件进行较小的更改。使用Openpyxl模块,可以非常有效且轻松地完成这些任务。
示例#importopenpyxlmodule
importopenpyxl
#CallaWorkbook()funcofopenpyxltocreateanewblankWorkbookobject
wb=openpyxl.Workbook()
#Getworkbookactivesheetfromtheactiveattribute
sheet=wb.active
#Cellobjectsalsohaverow,columnandcoordinateattributesthatprovide
#locationinformationforthecell.
#Thefirstroworcolumnintegeris1,not0.Cellobjectiscreatedby
#usingsheetobject'scell()method.
c1=sheet.cell(row=1,column=1)
#writingvaluestocells
c1.value="Vishesh"
c2=sheet.cell(row=1,column=2)
c2.value="Ved"
#OncehaveaWorksheetobject,onecanaccessacellobjectbyitsnamealso
#A2meanscolumn=1&row=2.
c3=sheet['A2']
c3.value="Python"
#B2meanscolumn=2&row=2.
c4=sheet['B2']
c4.value="Programming"
#AnytimeyoumodifytheWorkbookobjectoritssheetsandcells,the#spreadsheetfilewillnotbesaveduntilyoucallthe#save()workbookmethod.
wb.save("C:\\Users\\Vishesh\\Desktop\\demo.xlsx")