python 抓数_python 抓取alexa数据

#coding=utf-8

importjsonimporthttplib2importjsonimportxlrdimportxlwtimportosimportdatetimeimporttimeclassalexa:def __init__(self,key="7Z4ddd6ywaQuo6RkKfI3SzGeKn8Mavde"):

self.key=keydefWriteLog(self, message,date):

fileName= os.path.join(os.getcwd(), 'alexa/' + date + '.txt')

with open(fileName,'a') as f:

f.write(message)defWriteSheetRow(self,sheet, rowValueList, rowIndex, isBold):

i=0

style= xlwt.easyxf('font: bold 1')#style = xlwt.easyxf('font: bold 0, color red;')#红色字体

style2 = xlwt.easyxf('pattern: pattern solid, fore_colour yellow; font: bold on;') #设置Excel单元格的背景色为黄色，字体为粗体

for svalue inrowValueList:ifisBold:

sheet.write(rowIndex, i, svalue, style2)else:

sheet.write(rowIndex, i, svalue)

i= i + 1

defsave_Excel(self,headList,