python读取excel数据并去除空数据后写入另一个文档——python处理excel（二）

import xlrd
import xlwt
import openpyxl

#读取
wb = xlrd.open_workbook('myfile.xlsx')  # 读取工作簿
ws = wb.sheets()[0]  # 选第一个工作表
data = []#新建数组用于存储获取的数据
for i in range(2, ws.nrows):
    col1= ws.cell(i, 0).value	#第一列
    col2 = ws.cell(i, 1).value	#第二列
    col3 = ws.cell(i, 2).value 	#第三列 
    info_list = [col1, col2, col3]
    if info_list[0] != "":  # 去除空数据
        if col1 >100:
            data.append(info_list)
print(data)

#写入
from openpyxl import load_workbook
#打开write文档
file = "write.xlsx"
wb = load_workbook(file)
ws = wb.active
#写入数据
for i in data:
    ws.append(i)
#保存
wb.save("write.xlsx")