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')