连接excel表

112 阅读1分钟

目前我所搜集到的只有三种,欢迎补充!
方法一:
SZ=xlrd.open_workbook(“chaxun.xls”)
sz=SZ.sheet_by_name(“Sheet1”)
ww=copy(SZ)
ww.get_sheet(0).write(1,1,”asdasd”)
nrows=sz.nrows
os.remove(“chaxun.xls”)
ww.save(“chaxun.xls”)
fname=”chaxun.xls”
an=sz.cell_value(1,2)

方法二:
import win32com.client as win32
xl = win32.gencache.EnsureDispatch(“Excel.Application”)
ss = xl.Workbooks.add()
sh = ss.ActiveSheet
xl.Visible=True
sh.Cells(1,2).Value = “Python-to-Excel Demo”
warn(“Excel”)
ss.Close(False)
xl.Application.Quit()

链接word
import win32com.client as win32
app = “Word”
word = win32.gencache.EnsureDispatch(“%s.Application”%app)
doc = word.Documents.Add()
word.Visible = True
sleep(1)
rng = doc.Rang(0,0)
rng.InsertAfter(‘Python-to-hellow ‘)
warn(app)
doc.Close(False)
word.Application.Quit()