python写excel宏_python对具有宏excel的操作

安装pip install pypiwincomimportwin32com.client#excel

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

xlApp.Visible =0

xlApp.DisplayAlerts=0

FileName= r"C:\Users\ffm11\Desktop\mydata.xls"

#excel

xlBook =xlApp.Workbooks.Open(FileName)#屏蔽弹窗

xlBook.Checkcompatibility =Falsetry:#获取sheet

_sheet = xlBook.Worksheets(‘Sheet1‘)

_sheet2= xlBook.Worksheets(‘Sheet2‘)#获取指定单元格

print(_sheet.Cells(1,1).Value)#打印机

#_sheet.PrintOut()

#循环获取所有cell单元格

datatupe =_sheet.UsedRange.Valueprint(datatupe)#把所有单元格设置为空

_sheet.UsedRange.Value=""

#赋值sheet内容

_sheet.UsedRange.Value =_sheet2.UsedRange.Value#excel

#xlBook.SaveAs(FileName)#另存为

xlBook.Save()exceptException as e:print(e)finally:#excel

xlBook.Close()

xlApp.Quit()