Unicode in Excel files

John Machin sjmachin at lexicon.net
Wed Mar 21 06:07:36 EDT 2007


On Mar 21, 11:37 am, Carsten Haese <cars... at uniqsys.com> wrote:
> On Tue, 2007-03-20 at 16:47 -0700, Gerry wrote:
> > I'm still mystified why:
> >    qno was ever unicode,
>
> Thus quoth http://www.lexicon.net/sjmachin/xlrd.html "This module
> presents all text strings as Python unicode objects."
>

And why would that be? As the next sentence in the referenced docs
says, "From Excel 97 onwards, text in Excel spreadsheets has been
stored as Unicode."

Gerry, your "Q1" string was converted to Unicode when you wrote it
using pyExcelerator's Worksheet.write() method.

HTH,
John






More information about the Python-list mailing list