[Tutor] Python and excel writer: 'ascii' codec can't decode byte 0xf3 in position 49

Susana Iraiis Delgado Rodriguez susana.delgado_s at utzmg.edu.mx
Mon Oct 25 17:10:32 CEST 2010

Hello members:

I'm starting an script for geospatial information using python and gdal
binaries, but I have problems saving the data I get into an excel shee. At
the beginning I thought it was because the characters the files have for
some records, but I run the code in a way it saves the path for each file
I'm looking for. The script throws th error:
Python 2.6.6 (r266:84297, Aug 24 2010, 18:46:32) [MSC v.1500 32 bit (Intel)]
Type "help", "copyright", "credits" or "license" for more information.
>>> import imagen
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "imagen.py", line 20, in <module>
  File "C:\Python26\lib\site-packages\xlwt\Workbook.py", line 634, in save
    doc.save(filename, self.get_biff_data())
  File "C:\Python26\lib\site-packages\xlwt\Workbook.py", line 609, in
    shared_str_table   = self.__sst_rec()
  File "C:\Python26\lib\site-packages\xlwt\Workbook.py", line 571, in
    return self.__sst.get_biff_record()
  File "C:\Python26\lib\site-packages\xlwt\BIFFRecords.py", line 53, in
  File "C:\Python26\lib\site-packages\xlwt\BIFFRecords.py", line 66, in
    u_str = upack2(s, self.encoding)
  File "C:\Python26\lib\site-packages\xlwt\UnicodeUtils.py", line 50, in
    us = unicode(s, encoding)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xf3 in position 49:
 not in range(128)
My code is:
import os, time, socket
from xlwt import Workbook
from osgeo import gdal
from osgeo.gdalconst import *
from PIL import Image

file_list = []
folders = None
 # look in this (root) folder for files with specified extension
for root, folders, files in os.walk( "C:\\" ):
 file_list.extend(os.path.join(root,fi) for fi in files if
fi.endswith(".tif") or fi.endswith(".tiff") or fi.endswith(".gtif") or
fi.endswith(".ecw") or fi.endswith(".bil") or fi.endswith(".til") or
wrkbk = Workbook()
wksht = wrkbk.add_sheet('rasters')
for row, filepath in enumerate(file_list, start=1):
 #Llenar lista de archivos y ruta
 wksht.row(row).write(0, filepath)

Is there a way I can manage this error?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20101025/5bc864ce/attachment.html>

More information about the Tutor mailing list