xlrd与xlwt

关于python中的xlrd和xlwt两个关于excel读写的库
hummm~主要是想到以后数模可能用python处理数据!

库名:

import xlrd
import xlwt

下载地址:
[read]: https://pypi.org/project/xlrd/ (xlrd)
[write]: https://pypi.org/project/xlwt/ (xlwt)

import xlrd
import xlwt
data = xlrd.open_workbook(r'D:\software\python\sugar.xlsx')
table = data.sheets()[0]
nrows = table.nrows#行数
ncols = table.ncols#列数

for i in range(0,nrows): 
	rowValues = table.row_values(i)
	for item in rowValues:
		print (item, end = " ")#读
	print ()

file = xlwt.Workbook()
sheet1 = file.add_sheet('sheet1', cell_overwrite_ok = True)

for i in range(0, nrows):
	for j in range(0, ncols):
		sheet1.write(i,j,table.cell(i,j).value)#写入
file.save('demo2.xlsx') #save时有重复的不能覆盖

#官方
import xlwt
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',
	num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')

ws.write(0, 0, 1234.56, style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('example.xls')

赏

请作者喝养乐多

支付宝

微信