當前位置:成語大全網 - 新華字典 - 如何用python將數據寫入excel表格

如何用python將數據寫入excel表格

#?需安裝?xlrd-0.9.2?和?xlutils-1.7.1?這兩個模塊

from?xlwt?import?Workbook,?Formula

import?xlrd

book?=?Workbook()

sheet1?=?book.add_sheet('Sheet?1')

sheet1.write(0,0,10)

sheet1.write(0,1,20)

sheet1.write(1,0,Formula('A1/B1'))

sheet2?=?book.add_sheet('Sheet?2')

row?=?sheet2.row(0)

row.write(0,Formula('sum(1,2,3)'))

row.write(1,Formula('SuM(1;2;3)'))

row.write(2,Formula("$A$1+$B$1*SUM('ShEEt?1'!$A$1:$b$2)"))

book.save('formula.xls')

book?=?xlrd.open_workbook('formula.xls')

sheet?=?book.sheets()[0]

nrows=sheet.nrows

ncols=sheet.ncols

for?i?in?range(nrows):

for?j?in?range(ncols):

print?(sheet.cell(i,j).value)