#方法一：复制生成一个新表，可以写入单元格，保存为.xls文件

import xlrd

from xlutils.copy import copy

oldWb = xlrd.open_workbook("d:/1.xlsx")#先打开已存在的表

newWb = copy(oldWb)#复制

newWs = newWb.get_sheet(0)#取sheet表

newWs.write(2, 4, "pass")#写入 2行4列写入pass

newWb.save("d:/2.xls")

#方法二：在内存中建立一个新表，写入单元格，保存为.xls新文件

import xlwt

book = xlwt.Workbook()

sheet = book.add_sheet('Sheet1')

sheet.write(0,0,'hello')

sheet.write(1,0,'你好')

book.save('d:\hello.xls')

# 方法三： 以现有文件为模板，建立副本，修改单元格内容

import xlrd

from xlutils.copy import copy

book = xlrd.open_workbook('fruit.xlsx')

sheet = book.sheet_by_index(0)

newWb = copy(book)

newWs = newWb.get_sheet(0)#取sheet表

newWs.write(2, 4, "pass")#写入 2行4列写入pass

newWb.save("new.xls")

# 方法四：由列表类型数据建立新的excel文件

import xlwt

proj = ['名称','单价/元','库存/kg']

fruit = ['苹果','梨','香蕉','橘子']

price = [8,3.5,4.5,3.8]

storage = [150,130,100,300]

book = xlwt.Workbook()

sheet = book.add_sheet('Sheet1')

for i in range(0,len(proj)):

sheet.write(0,i,proj[i]) #按行插入行标题

for i in range(0,len(fruit)):

sheet.write(i+1,0,fruit[i]) #插入第一列水果名称

for i in range(0,len(price)):

sheet.write(i+1,1,price[i]) #插入第二列单价

for i in range(0,len(storage)):

sheet.write(i+1,2,storage[i]) #插入第三列库存

book.save('fruit2.xls')

# 方法五新建.xlsx文件

import openpyxl

book = openpyxl.Workbook()

sheet = book.create_sheet('Sheet1',0)

proj = ['名称','单价/元','库存/kg']

fruit = ['苹果','香蕉','梨','橘子']

price = [8,3.5,4.5,3.8]

storage = [150,130,300,100]

for i in range(len(proj)):

sheet.cell(1,i+1,proj[i])

for i in range(len(fruit)):

sheet.cell(i+2,1,fruit[i])

for i in range(len(price)):

sheet.cell(i+2,2,price[i])

for i in range(len(storage)):

sheet.cell(i+2,3,storage[i])

book.save('fruit2.xlsx')

rows = sheet.max_row

sheet.insert_rows(rows+2)

cherry = ['樱桃',17,80]

for j in cherry:

sheet.cell(rows+1,cherry.index(j)+1,j) #向单元格写入内容j

book.save('fruit2.xlsx')

#修改单元格内容

sheet.cell(3,2,4)

sheet['B3'] = 5

book.save('fruit2.xlsx')

#追加行内容

straberry = ['草莓',20,50]

sheet.append(straberry)

book.save('fruit2.xlsx')