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 have discovered that the
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,
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
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? What
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 think?)
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 called
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 wrote: