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)

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