python实战excel_实战python 读写EXCEL表

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('文件保存成功')