python导出excel带下拉选项_python list格式数据excel导出方法

如下所示： # _*_ coding:utf-8 _*_

#-----------------------------------------------

# import modules

#-----------------------------------------------

import os

import xlwt

import sys

import types

def set_style(name, height, bold = False):

style = xlwt.XFStyle() #初始化样式

font = xlwt.Font() #为样式创建字体

font.name = name

font.bold = bold

font.color_index = 4

font.height = height

style.font = font

return style

def write_excel():

#创建工作簿

workbook = xlwt.Workbook(encoding='utf-8')

#创建sheet

data_sheet = workbook.add_sheet('demo')

#列表格式数据

excelData = [

['tdate', u'交易所', u'股票代码'],

[20170103, 'CNSESZ', '300319'],

[20170104, 'CNSESZ