openpyxl基础知识

#-*- coding: UTF-8 -*-

importsys

importtime

importurllib

importurllib2

importrequests

importnumpyasnp

frombs4importBeautifulSoup

fromopenpyxlimportWorkbook

reload(sys)

sys.setdefaultencoding('utf8')

#Some User Agents

hds=[{'User-Agent':'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6'},\

{'User-Agent':'Mozilla/5.0 (Windows NT 6.2) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.12 Safari/535.11'},\

{'User-Agent':'Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.2; Trident/6.0)'}]

fromopenpyxlimportWorkbook

wb = Workbook()

# grab the active worksheet

ws = wb.active

# Data can be assigned directly to cells

ws['A1'] =42

# Rows can also be appended

ws.append([1,2,3])

# Python types will automatically be converted

importdatetime

ws['A2'] = datetime.datetime.now()

# Save the file

wb.save("sample.xlsx")