here s one line from a spreadsheet, as saved in python;
[text:u'Bob Dobbs', number:0.0, number:1.0, text:u'n/0!', number:0.0,
number:0.0, number:0.0, number:0.0, number:0.0, number:0.0]
[text:u'Connie Dobbs', number:22.0, number:4.0, number:0.17001,
number:11.0, number:0.5, number:6.0,
Kirk Bailey wrote:
> I extracted cell 0,0 and it is
> >>> x
> u'Bob Dobbs'
> >>>
>
> So I did this:
> >>> str(x)
> 'Bob Dobbs'
> >>>
> >>> b[1:-1]
> 'ob Dobb'
> >>>
> oops... well,then i did this
> >>> print b
> Bob Dobbs
> >>>
> which is as I need it. any use to the rest of the list?
You
Kirk Bailey wrote:
> ok, I installed XLRD and can load a xls file; it works quite well BTW. Now
> it is returning Unicode objects. I need to strip that to a simple string
> value. Is there a recommended way or module for handling Unicode objects?
What kind of characters are in the Excel file? Wh
ok, I installed XLRD and can load a xls file; it works quite well BTW. Now
it is returning Unicode objects. I need to strip that to a simple string
value. Is there a recommended way or module for handling Unicode objects?
Kirk Bailey wrote:
> Ii want to read a xls file and use the data in part
Really? What are you having trouble with? I have used pyexcelerator
under Windows without problems.
--
John.
On 16/08/07, Kirk Bailey <[EMAIL PROTECTED]> wrote:
> looks good. works bad; this is a windows workplace. ouch. Advice please
> (other than change operating systems)?
>
> John Fouhy wro
Alan Gauld <[EMAIL PROTECTED]> wrote:
"Kirk Bailey" wrote
> Ii want to read a xls file and use the data in part of it. What
> module
> would help make sense of one?
If the data is straighforward you might find it easier to save it as a
csv file first.
But otherwise there is a module calle
"Kirk Bailey" <[EMAIL PROTECTED]> wrote
> Ii want to read a xls file and use the data in part of it. What
> module
> would help make sense of one?
If the data is straighforward you might find it easier to save it as a
csv file first.
But otherwise there is a module called pyexcelerator (I th