Python办公自动化套件 | 开发日志

Python办公自动化套件

March 19, 2022

类别: Python 标签: word python-docx excel openpyxl

操作 Word 文档

安装依赖库 python-docx

  1. pip install python-docx

示例

  1. from docx import Document
  2. from docx.shared import Inches
  4. document = Document()
  6. document.add_heading('Document Title', 0)
  8. p = document.add_paragraph('A plain paragraph having some ')
  9. p.add_run('bold').bold = True
  10. p.add_run(' and some ')
  11. p.add_run('italic.').italic = True
  13. document.add_heading('Heading, level 1', level=1)
  14. document.add_paragraph('Intense quote', style='Intense Quote')
  16. document.add_paragraph(
  17.     'first item in unordered list', style='List Bullet'
  18. )
  19. document.add_paragraph(
  20.     'first item in ordered list', style='List Number'
  21. )
  23. document.add_picture('monty-truth.png', width=Inches(1.25))
  25. records = (
  26.     (3, '101', 'Spam'),
  27.     (7, '422', 'Eggs'),
  28.     (4, '631', 'Spam, spam, eggs, and spam')
  29. )
  31. table = document.add_table(rows=1, cols=3)
  32. hdr_cells = table.rows[0].cells
  33. hdr_cells[0].text = 'Qty'
  34. hdr_cells[1].text = 'Id'
  35. hdr_cells[2].text = 'Desc'
  36. for qty, id, desc in records:
  37.     row_cells = table.add_row().cells
  38.     row_cells[0].text = str(qty)
  39.     row_cells[1].text = id
  40.     row_cells[2].text = desc
  42. document.add_page_break()
  44. document.save('demo.docx')

Python办公自动化套件 _ 开发日志 - 图1

操作 Excel 文档

安装依赖库 openpyxl

  1. pip install openpyxl

示例

  1. from openpyxl import Workbook
  2. wb = Workbook()
  4. # grab the active worksheet
  5. ws = wb.active
  7. # Data can be assigned directly to cells
  8. ws['A1'] = 42
  10. # Rows can also be appended
  11. ws.append([1, 2, 3])
  13. # Python types will automatically be converted
  14. import datetime
  15. ws['A2'] = datetime.datetime.now()
  17. # Save the file
  18. wb.save("sample.xlsx")

参考资料