Python读excel,此文章只简单介绍两个模块用法，我有时间会把具体写法传上来
xlrd模块读excel
import xlrd data = xlrd.open_workbook("window regulator.xlsx") #打开excel table = data.sheet_by_name("Sheet2")#读sheet nrows = table.nrows #获得行数 result = [] for i in range(1,nrows): # rows = table.row_values(i) #行的数据放在数组里 sku = rows[0] keyword = str(rows[1]).split("-")[1] + " "+ str(rows[2]).replace("|"," ") + " window regulator" kind = rows[3] result.append([sku, keyword,kind]) print(result) SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
pandas模块读excel
import pandas as pd import numpy import csv import xlrd #读入sku df = pd.read_excel("window regulator.xlsx",sheetname="Sheet2") #读excel skus = df["sku"].values for sku in skus : df1 = pd.read_csv("sku\\feedback_"+str(sku)+".csv",encoding="utf-8") df1 = df1[(df1.price < 60) & (df1.price >10)] df1.to_csv("sku\\feedback_"+str(sku)+".csv",encoding="utf-8",index = False) #写入到csv 
更多精彩
