fromdocximportDocumentfromdocx.sharedimportInchesdocument=Document()document.add_heading('Document Title',0)p=document.add_paragraph('A plain paragraph having some ')p.add_run('bold').bold=Truep.add_run(' and some ')p.add_run('italic.').italic=Truedocument.add_heading('Heading, level 1',level=1)document.add_paragraph('Intense quote',style='Intense Quote')document.add_paragraph('first item in unordered list',style='List Bullet')document.add_paragraph('first item in ordered list',style='List Number')document.add_picture('monty-truth.png',width=Inches(1.25))records=((3,'101','Spam'),(7,'422','Eggs'),(4,'631','Spam, spam, eggs, and spam'))table=document.add_table(rows=1,cols=3)hdr_cells=table.rows[0].cellshdr_cells[0].text='Qty'hdr_cells[1].text='Id'hdr_cells[2].text='Desc'forqty,id,descinrecords:row_cells=table.add_row().cellsrow_cells[0].text=str(qty)row_cells[1].text=idrow_cells[2].text=descdocument.add_page_break()document.save('demo.docx')
fromopenpyxlimportWorkbookwb=Workbook()# grab the active worksheet
ws=wb.active# Data can be assigned directly to cells
ws['A1']=42# Rows can also be appended
ws.append([1,2,3])# Python types will automatically be converted
importdatetimews['A2']=datetime.datetime.now()# Save the file
wb.save("sample.xlsx")