python xlrd xlwt擷取資料到execl表格範例

標籤：ESS   user   exce   sheet   mock   res   start   表格   enc   

import mock

#coding:gbk
from xlrd import open_workbook
import mock
import xlrd
import xlwt
from xlutils.copy import copy
import os
acct = mock.acct_id
data = mock.acct_data
start_time = mock.start_time
print start_time
end_time = mock.end_time5
haoshi = mock.result_end
req_sn = mock.mock(acct).format(acct, data)[‘request_sn‘]
ww = ["acct",‘wwwwww‘]
print
if os.path.exists(‘C:\Users\Administrator\desktop\excel.xls‘):
pass
else:
book = xlwt.Workbook(encoding=‘gbk‘,style_compression=0)
sheet = book.add_sheet(‘資料統計‘,cell_overwrite_ok=True)
book.save(‘C:\Users\Administrator\desktop\excel.xls‘)
book = open_workbook(‘C:\Users\Administrator\desktop\excel.xls‘,‘w+b‘)
rows = book.sheets()[0].nrows
excel = copy(book)
table = excel.get_sheet(0)
row = rows
for i in range(7):
table.col(i).width=256*35
row0 = [u‘response_sn‘,u‘retcode‘,u‘acct_id‘,u‘請求時間‘,u‘結束時間‘,u‘耗時‘]
row1 = [req_sn, mock.retcode, acct, start_time, end_time, haoshi]
if row == 0:
for i in range(len(row0)):
table.write(row, i, row0[i])
table.write(row + 1 , i, row1[i])
else:
for i in range(0,len(row0)):
table.write(row,i,row1[i])
excel.save(‘C:\Users\Administrator\desktop\excel.xls‘)

python xlrd xlwt擷取資料到execl表格範例