商品信息有关内部信息不便透露,python程序做登录以及商品数据的下载,因为只能下载excel,所以需要转正csv,这里需要做sheet分页读取。
import csv
import openpyxl
def xlsx_to_csv_data():
data = openpyxl.load_workbook('/home/hadoop/data/ali/a.xlsx')
sheets = data.get_sheet_names()
list1 = []
for t in range(len(sheets)):
sheet = data.get_sheet_by_name(sheets[t])
len_row = sheet.max_row
len_column = sheet.max_column
if t == 0:
for i in range(1,len_row+1):
list2 = []
for j in range(1,len_column+1):
list2.append(sheet.cell(row=i,column=j).value)
list1.append(list2)
else:
for i in range(2,len_row+1):
list2 = []
for j in range(1,len_column+1):
list2.append(sheet.cell(row=i,column=j).value)
list1.append(list2)
with open('/home/hadoop/data/ali/a.csv', 'w', newline='') as f:
writer = csv.writer(f)
writer.writerows(list1)
f.close()
if __name__ == '__main__':
xlsx_to_csv_data()