素手烹茶|“蟒蛇”py对Excel的读取——数据操作用它，老板都得重新认识你( 三 ) 在python自动化中

当然xlwt功能远远不止这些，它甚至可以设置各种样式之类的。附上一点例子
Examples Generating Excel Documents Using Python’s xlwt
Here are some simple examples using Python’s xlwt library to dynamically generate Excel documents.
Please note a useful alternative may be ezodf, which allows you to generate ODS (Open Document Spreadsheet) files for LibreOffice / OpenOffice. You can check them out at:
The Simplest Example
import xlwt
workbook = xlwt.Workbook(encoding = 'ascii')
worksheet = workbook.add_sheet('My Worksheet')
worksheet.write(0, 0, label = 'Row 0, Column 0 Value')
workbook.save('Excel_Workbook.xls')
Formatting the Contents of a Cell
import xlwt
workbook = xlwt.Workbook(encoding = 'ascii')
worksheet = workbook.add_sheet('My Worksheet')
font = xlwt.Font() # Create the Font
font.name = 'Times New Roman'
font.bold = True
font.underline = True
font.italic = True
style = xlwt.XFStyle() # Create the Style
style.font = font # Apply the Font to the Style
worksheet.write(0, 0, label = 'Unformatted value')
worksheet.write(1, 0, label = 'Formatted value', style) # Apply the Style to the Cell
workbook.save('Excel_Workbook.xls')
Attributes of the Font Object
font.bold = True # May be: True, False
font.italic = True # May be: True, False
font.struck_out = True # May be: True, False
font.underline = xlwt.Font.UNDERLINE_SINGLE # May be: UNDERLINE_NONE, UNDERLINE_SINGLE, UNDERLINE_SINGLE_ACC, UNDERLINE_DOUBLE, UNDERLINE_DOUBLE_ACC
font.escapement = xlwt.Font.ESCAPEMENT_SUPERSCRIPT # May be: ESCAPEMENT_NONE, ESCAPEMENT_SUPERSCRIPT, ESCAPEMENT_SUBSCRIPT
font.family = xlwt.Font.FAMILY_ROMAN # May be: FAMILY_NONE, FAMILY_ROMAN, FAMILY_SWISS, FAMILY_MODERN, FAMILY_SCRIPT, FAMILY_DECORATIVE
font.charset = xlwt.Font.CHARSET_ANSI_LATIN # May be: CHARSET_ANSI_LATIN, CHARSET_SYS_DEFAULT, CHARSET_SYMBOL, CHARSET_APPLE_ROMAN, CHARSET_ANSI_JAP_SHIFT_JIS, CHARSET_ANSI_KOR_HANGUL, CHARSET_ANSI_KOR_JOHAB, CHARSET_ANSI_CHINESE_GBK, CHARSET_ANSI_CHINESE_BIG5, CHARSET_ANSI_GREEK, CHARSET_ANSI_TURKISH, CHARSET_ANSI_VIETNAMESE, CHARSET_ANSI_HEBREW, CHARSET_ANSI_ARABIC, CHARSET_ANSI_BALTIC, CHARSET_ANSI_CYRILLIC, CHARSET_ANSI_THAI, CHARSET_ANSI_LATIN_II, CHARSET_OEM_LATIN_I
font.colour_index = ?
font.get_biff_record = ?
font.height = 0x00C8 # C8 in Hex (in decimal) = 10 points in height.
font.name = ?
font.outline = ?
font.shadow = ?
Setting the Width of a Cell
import xltw
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('My Sheet')
worksheet.write(0, 0, 'My Cell Contents')
worksheet.col(0).width = 3333 # 3333 = 1" (one inch).
workbook.save('Excel_Workbook.xls')
Entering a Date into a Cell
import xlwt
import datetime
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('My Sheet')
style = xlwt.XFStyle()
style.num_format_str = 'M/D/YY' # Other options: D-MMM-YY, D-MMM, MMM-YY, h:mm, h:mm:ss, h:mm, h:mm:ss, M/D/YY h:mm, mm:ss, [h]:mm:ss, mm:ss.0

素手烹茶|“蟒蛇”py对Excel的读取——数据操作用它，老板都得重新认识你( 三 )

推荐阅读

午间时刻|王者荣耀：猪八戒战令皮3D视角，腰封超霸气，变色龙很乖，尾巴看了想摸！

乌梅玫瑰花茶的作用及禁忌,玫瑰花茶的作用哪些

迈克尔·乔丹■单挑输球，被喷了句垃圾话就把队友交易走！乔丹真是惹不起

阿萨姆红茶醒茶方法,阿萨姆红茶泡法

海关发布|那些常见的进口玻璃小药瓶

北京卫视|“对不起大家！”石景山万达女子自述为何破坏报警器外出

巴氏征阳性临床意义

青年|盘点kpl上那些饱受争议的教练：estar和AG超玩会都没能躲得过去！

徽柔怀吉粉|本以为不合适，看到成品是我眼拙了，吉克隽逸长得黑还要穿吊带裙

睡前10分钟瘦身瑜伽动作有什么

该咋滴才可以发qq邮箱，怎么把文件发送到别人的邮箱里

舍里|一人内疚自杀，自己却无罪，英少年开宝马出车祸：一人当场死亡

郭梓宁|现场|中国奥园：今年拿地预算350亿至400亿元

农历|古人说“闰四月，两头春；老农民，卖儿孙”，到底是啥意思

台海网■武汉解封！民进党还有什么理由限制台胞回台？陆委会又“打太极”

805路等13条跨京冀运营线路恢复全线运营

DM科技|折叠屏设计大改，不再是好评众多，三星设计专利再曝光

如何将旧手机信息迁移到新手机？

小幺精时尚手记好看炸了，今夏必买“瘦瘦裙”！显瘦又减龄

宁夏银川|宁夏银川：新建居住区须按标准配建养老服务设施