Python-сообщество

import xlwt as xl
x = xl.Workbook()
x.add_sheet(u'Лист1')
x.save('123.xls')

# coding:utf-8

>>> x.add_sheet(u'Лист1'.encode('cp1251'))

Traceback (most recent call last):
  File "<pyshell#3>", line 1, in <module>
    x.add_sheet(u'Лист1'.encode('cp1251'))
  File "D:\Python26\lib\encodings\cp1251.py", line 12, in encode
    return codecs.charmap_encode(input,errors,encoding_table)
UnicodeEncodeError: 'charmap' codec can't encode characters in position 0-3: character maps to <undefined>

# -*- coding: utf8 -*-
import xlwt as xlw
#работаем с экселем
class cxlslog:
    filename = ""
    wl = None
    def __init__(self,fname):
        self.wl = xlw.Workbook()
        self.filename = fname
    
    def addlist(self,lname):
        self.wl.add_sheet(lname)
        
    def save(self):
        self.wl.save(self.filename)
    
#работаем с экселем