opepyxl是一个Pytho库,用于读取/写入Excel2010xlsx/xlsm/xltx/xltm文件。
它的诞生是因为缺少可从Pytho本地读取/写入OfficeOpeXML格式的库。示例代码如下:
fromopepyxlimportWorkbookwb=Workbook()#grabtheactiveworksheetws=wb.active#Datacabeassigeddirectlytocellsws['A1']=42#Rowscaalsobeappededws.apped([1,2,3])#Pythotypeswillautomaticallybecovertedimportdatetimews['A2']=datetime.datetime.ow()#Savethefilewb.save("sample.xlsx")






评论