python win32con_python win32com.client

#创建

#word

w = win32com.client.Dispatch("Word.Application")

w= win32com.client.DispatchEx("Word.Application")#使用启动独立的进程

#excel

xlApp = win32com.client.Dispatch("Excel.Application")#后台运行, 不显示, 不警告

w.Visible =0;

w.DisplayAlerts=0;#打开新的文件

#word

doc =w.Documents.Open(FileName)#new_doc = w.Documents.Add() #创建新的文档

#excel

xlBook =xlApp.Workbooks.Open(FileName)#new_xlBook = xlApp.Workbooks.Add() #创建新的工作簿

#插入文字

#word

myRange =doc.Range(0, 0)

myRange.InsertBefore("hello from Python")#excel

#使用样式

wordStyle =myRange.Select()

wordStyle.Style=constants.wdStyleHeading1#正文文字替换

w.Selection.Find.ClearFormatting()

w.Selection.Find.Replacement.ClearFormatting()

w.Selection.Find.Execute(OldStr, False, False, False, False, False, True,1, True, NewStr, 2)#表格操作

#word

doc.Tables[0].Rows[0].Cells[0].Range.Text = "hello world Python"worddoc.Tables[0].Rows.Add()#增加一行

#excel

#获取

_sheet =xlBook.Worksheets(sheet)

_sheet.Cell(row, col).Value#设置

_sheet =xlBook.Worksheets(sheet)

_sheet.Cells(row, col).Value=values#范围操作

_sheet =xlBook.Worksheets(sheet)

_sheet.Range(_sheet.Cell(row1, col1), _sheet.Cell(row2, col2)).Value#添加图片

#excel

_sheet =xlBook.Worksheets(sheet)

_sheet.Shapes.AddPicture(picturename,1, 1, Left, Top, Width, Height)#copy 工作簿

sheets=xlBook.Worksheets

sheets(1).Copy(None, sheets(1))#转换为html

#word

wc =win32com.client.constants

w.ActiveDocument.WebOptions.RelyOnCSS= 1w.ActiveDocument.WebOptions.OptimizeForBrowser= 1w.ActiveDocument.WebOptions.BrowserLevel= 0 #constants.wdBrowserLevelV4

w.ActiveDocument.WebOptions.OrganizeInFolder =0

w.ActiveDocument.WebOptions.UseLongFileNames= 1w.ActiveDocument.WebOptions.RelyOnVML=0

w.ActiveDocument.WebOptions.AllowPNG= 1w.ActiveDocument.SaveAs(FileName, FileFormat=wc.wdFormatHTML)#打印

doc.PrintOut()#保存

#excel

xlBook.SaveAs(FileName)#另存为

xlBook.Save()#关闭

#word#doc.Close()

w.Documents.Close(wc.wdDoNotSaveChanges)

w.Quit()#excel

xlBook.Close(SaveChange =0)

xlBook.Quit()