def saveData(savePath):
book = xlwt.workbook(encoding="utf-8", style_compression=0)
sheet = book.add_sheet("豆瓣最受欢迎的Top250部电影", cell_overwrite_ok=True)
col = ('电影名称', '评分', '评论人数', '短评')
for i in range(0,4):
sheet.write(0,i, col[i])
for i in range(0, 250):
data = datalist[i]
for j in range(0,4):
sheet.write(i+1, j, data[j]) #给表格添加数据
book.save(savepath) #保存excel
return
def data_write(y):
file = xlwt.workbook(encoding='utf-8')
sheet = file.add_sheet(u'final', cell_overwrite_ok=True)
i = 0
for data in y:
for j in range(len(data)):
sheet.write(i, j, data[j])
i = i + 1
file.save('结果.xlsx')
#输出到txt文本，在excel把十共同好友列表输入excel
#mysql 的 安装和链接 增删改查。。
def WritrData(self):
workBook=write.workbook()
sheet=workBook.add_sheet('info')
count=0
cols=[]
#Open the network workbook
netWorkbook = xlrd.open_workbook("Network.xlsx")
netSheet = netWorkbook.sheet_by_name('Networks')
#Start at the top of the Networks
netR = 1
#Stop when Network is matched onto
netStop = 0
#Define number of rows in Networks
numNetRows = netSheet.nrows
#Open the contracts spreadsheet
conWorkbook = xlwt.workbook("Contracts.csv")
conSheet = conWorkbook.add_sheet('Contracts')
#Add Column headings to Contracts
conSheet.write(0, 0, 'Source Network')
conSheet.write(0, 1, 'Destination Network')
conSheet.write(0, 2, 'Destination Port')
#Save contracts spreadsheet
conWorkbook.save
#Start at the top of Contracts
conR = 1
#Iterate through firewall logs
while logR != numLogRows:
def write_excel(path):
excel = xlwt.workbook(encoding='ascii') # 创建表格
sheet = excel.add_sheet('my excel') # 创建工作表
sheet.write(0,0,label='row 0,col 0,value') # 向单元格写入内容
excel.save(path + "ExcelDemo.xls") # 保存表格
# read xls file
import xlrd
book = xlrd.open_workbook("file_name.xls")
print(book.nsheets)
print(book.sheet_names())
first_sheet = book.sheet_by_index(0)
print(first_sheet.row_values(0))
cell = first_sheet.cell(3, 1)
print(cell)
# write xls file
import xlwt
workbook = xlwt.workbook(encoding="utf-8")
sheet1 = book.add_sheet("sheet_name1")
sheet2 = book.add_sheet("sheet_name2")
sheet3 = book.add_sheet("sheet_name3")
sheet1.write(0, 0, 'Sheet 1') # 'Sheet 1' - write some value to cell
sheet2.write(5, 0, 'Sheet 2') # 5 - row
sheet3.write(0, 10, 'Sheet 3') # 10 - column
workbook.save("file_name.xls")
"""
import xlrd
exbook=xlrd.open_workbook("a.xlsx")
sheet=exbook.sheet_by_index(0)
total_row=sheet.nrows
total_cols=sheet.ncols
for i in range(4):
for j in range(2):
cell_value=sheet.cell(i,j).value
print cell_value
print ""
"""
import xlwt
wb=xlwt.workbook()
sh=wb.add_sheet("sheet.1")
sh.write(0,0,"data")
wb.save("b.xlsx")
#数据库导到Excel中
import xlwt
import pymysql
f =xlwt.Workbook (encoding= 'utf-8')
sheet =f.add_sheet('qwe')
conn = pymysql .connect(host='192.168.2.225',port = 3306,user = '******',passwd= '123456')
abc = conn.cursor()
abc.execute('use text3;')
abc.execute('select * from shuju;')
a = abc.fetchall()
# print(a)
for i in range(len(a)):
for j in range(len(a[i])):
sheet.write(i,j,a[i][j])
f.save('abc.xls')
f=xlwt.workbook(encoding='utf-8')
sheet=f.add_sheet('qwe')
conn=pymysql.connect(host='192.168.0.1',port='3306',user='******',passwd='112345')
abc=conn.cursor()
abc.execute('use text')
abc.execute('select * from shuju')
a=abc.fetchall()
for i in range(len(a)):
for j in range(len(i)):
sheet.write(i,j,a[i][j])
f.save(a.xls)
#Excel导到数据库
import pymysql
import xlrd
ff = xlrd.open_workbook('b.xls')