![](https://img2020.cnblogs.com/blog/1902253/202009/1902253-20200929181742164-241933239.png)
python/EXCEL读取保存
import xlwt
import xlrd
import os
def read_excel(filename):
row_list = []
bk = xlrd.open_workbook(filename)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print("no sheet in %s named Sheet1" % filename)
else:
# 获取行数
nrows = sh.nrows
# 获取各行数据
for i in range(1, nrows):
row_data = sh.row_values(i)
row_list.append(row_data)
print(row_list)
return row_list
class WriteExcel:
def __init__(self):
self.work_book = xlwt.Workbook(encoding='utf-8')
self.sheet = self.work_book.add_sheet('sheet', cell_overwrite_ok=True)
self.sheet.write(0, 0, u'货号')
self.sheet.write(0, 1, u'尺码')
self.sheet.write(0, 2, u'价格')
def write(self, data_list):
for index, data in enumerate(data_list):
count = index + 1
self.sheet.write(count, 0, data[0])
self.sheet.write(count, 1, data[1])
self.sheet.write(count, 2, data[2])
if os.path.exists('price.xlsx'):
# 删除指定路径下的文件
os.remove('price.xlsx')
print('已将旧数据文件删除')
self.work_book.save('price.xlsx')
print('文件保存成功')