python 读取数据

读取数据

读取数据文章链接

写数据到excel中

例子1

# -*- codeing = utf-8 -*-
import xlwt

# 1. 创建workbook对象
workbook = xlwt.Workbook(encoding="utf-8")
# 2. 创建工作表
worksheet = workbook.add_sheet("sheet1")
# 3. 写入数据，第一行参数”行“，第二个参数”列“，第三个参数内容
worksheet.write(0, 0, "hello")  # 
# 4. 保存数据表
workbook.save("E:\\Desktop\\new.xls")

例子2 打印乘法表

# -*- codeing = utf-8 -*-
import xlwt

# 创建workbook对象
workbook = xlwt.Workbook(encoding="utf-8")
# 创建工作表
worksheet = workbook.add_sheet('sheet1')
for i in range(0, 9):
    for j in range(0, i + 1):
        worksheet.write(i, j, "%d * %d = %d " % (i + 1, j + 1, (i + 1) * (j + 1)))

# 保存数据表
workbook.save("E:\\Desktop\\new.xls")