在网上搜索的时候，经常看到两种打开方式: dispatch和EnsureDispatch

  1. import win32com.client as win32
  2. xl_dis = win32.Dispatch("Excel.Application")
  1. import win32com.client as win32
  2. xl_ens = win32.gencache.EnsureDispatch("Excel.Application")

两种方式的差别参见：

https://stackoverflow.com/questions/50127959/win32-dispatch-vs-win32-gencache-in-python-what-are-the-pros-and-cons

  1. #创建
  3. #word
  4. w = win32com.client.Dispatch("Word.Application")    
  5. w = win32com.client.DispatchEx("Word.Application")#使用启动独立的进程
  7. #excel
  8. xlApp = win32com.client.Dispatch("Excel.Application")
  10. #后台运行, 不显示, 不警告
  11. w.Visible = 0;
  12. w.DisplayAlerts = 0;
  14. #打开新的文件
  16. #word
  17. doc = w.Documents.Open(FileName)
  18. #new_doc = w.Documents.Add() #创建新的文档
  20. #excel
  21. xlBook = xlApp.Workbooks.Open(FileName)
  22. #new_xlBook = xlApp.Workbooks.Add() #创建新的工作簿
  25. #插入文字
  27. #word
  28. myRange = doc.Range(0, 0)
  29. myRange.InsertBefore("hello from Python")
  31. #excel
  35. #使用样式
  36. wordStyle = myRange.Select()
  37. wordStyle.Style = constants.wdStyleHeading1
  39. #正文文字替换
  40. w.Selection.Find.ClearFormatting()
  41. w.Selection.Find.Replacement.ClearFormatting()
  42. w.Selection.Find.Execute(OldStr, False, False, False, False, False, True, 1, True, NewStr, 2)
  45. #表格操作
  47. #word
  48. doc.Tables[0].Rows[0].Cells[0].Range.Text = "hello world Python"
  49. worddoc.Tables[0].Rows.Add() #增加一行
  51. #excel
  53. #获取
  54. _sheet = xlBook.Worksheets(sheet)
  55. _sheet.Cell(row, col).Value
  57. #设置
  58. _sheet = xlBook.Worksheets(sheet)
  59. _sheet.Cells(row, col).Value = values
  61. #范围操作
  62. _sheet = xlBook.Worksheets(sheet)
  63. _sheet.Range(_sheet.Cell(row1, col1), _sheet.Cell(row2, col2)).Value
  66. #添加图片
  68. #excel
  69. _sheet = xlBook.Worksheets(sheet)
  70. _sheet.Shapes.AddPicture(picturename, 1, 1, Left, Top, Width, Height)
  73. #copy 工作簿
  75. sheets = xlBook.Worksheets
  76. sheets(1).Copy(None, sheets(1))
  80. #转换为html
  82. #word
  83. wc = win32com.client.constants
  84. w.ActiveDocument.WebOptions.RelyOnCSS = 1
  85. w.ActiveDocument.WebOptions.OptimizeForBrowser = 1
  86. w.ActiveDocument.WebOptions.BrowserLevel = 0 # constants.wdBrowserLevelV4
  87. w.ActiveDocument.WebOptions.OrganizeInFolder = 0
  88. w.ActiveDocument.WebOptions.UseLongFileNames = 1
  89. w.ActiveDocument.WebOptions.RelyOnVML = 0
  90. w.ActiveDocument.WebOptions.AllowPNG = 1
  91. w.ActiveDocument.SaveAs(FileName, FileFormat = wc.wdFormatHTML)
  93. #打印
  94. doc.PrintOut()
  96. #保存
  99. #excel
  100. xlBook.SaveAs(FileName)#另存为
  101. xlBook.Save()
  104. #关闭
  106. #word
  107. #doc.Close()
  108. w.Documents.Close(wc.wdDoNotSaveChanges)
  109. w.Quit()
  112. #excel
  113. xlBook.Close(SaveChange = 0)
  114. xlBook.Quit()

 

 

版权声明：本文为robin2022原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/robin2022/p/16317499.html