import xlwt
def main():
book = xlwt.Workbook()
sheet1 = book.add_sheet('MySheet1')
cols = ['A', 'B', 'C', 'D', 'E']
txt = '行 %s, 列%s'
for num in range(5):
row = sheet1.row(num)
for index, col in enumerate(cols):
value = txt % (num+1, col)
row.write(index, value)
book.save(r'C:\test\mytest.xls')
#--------------------
if __name__ == '__main__':
main()
from datetime import date
import xlwt
def main():
book = xlwt.Workbook()
sheet1 = book.add_sheet('MySheet1')
cols = ['A', 'B', 'C', 'D', 'E']
txt = '行 %s, 列%s'
for num in range(5):
row = sheet1.row(num)
for index, col in enumerate(cols):
value = txt % (num+1, col)
row.write(index, value)
value = date(2009,3,18)
fmt = xlwt.Style.easyxf('''
font: name Arial;
borders: left thick, right thick, top thick, bottom thick;
pattern: pattern solid, fore_colour red;
''', num_format_str='YYYY-MM-DD')
sheet1.write(6,1,value, fmt)
book.save(r'C:\test\mytest3.xls')
#----------------------------------------------------------------------
if __name__ == '__main__':
main()
联系客服