这里我们简答介绍一下,使用python中xlwt库将文本写如到Excel中
话不多说,上代码
导入库
import xlwt
代码
class write_excel(object):
def __init__(self, save_path, sheet_name):
'''
:param save_path: 保存地址
:param sheet_name: 表名
'''
self.save_path = save_path
self.sheet_name = sheet_name
def write_data(self):
book = xlwt.Workbook(encoding='utf-8', style_compression=0)
sheet = book.add_sheet(self.sheet_name, cell_overwrite_ok=True)
# 这只是实验数据 可以根据具体要求更改
for i in range(0, 100):
for j in range(1, 100):
sheet.write(i, j, "xxx")
book.save(self.save_path)
print(1)
if __name__ == '__main__':
write_excel = write_excel("C:/Users/lihu/Desktop/shiyan.xls", "demo1").write_data()