taking data from .xls file to python list

Question

Open the workbook

import xlrd
wb = xlrd.open_workbook('/home/AlAhAb65/Desktop/Parameter.xls')

Check the sheet names

wb.sheet_names()

Get the first sheet either by name

sh = wb.sheet_by_name('QA_TEST')
l = []

Iterate through rows, returning each as a list that you can index:

for rownum in range(sh.nrows):
    l.append(sh.row_values(rownum))
print l

When I am reading from excel to python list there always come ‘u’ before every data. How can I get rid of this? Is everything read as string? Do I have to convert every time?

It means they're unicode (as they should be stored in excel) - why does this bother you? (eg: does it cause encoding issues later/etc...) — Jon Clements
– Jon Clements, Commented May 14, 2013 at 14:20
And just an aside, instead of your loop, in Python 2.x you can use - map(ws.row_values, xrange(sh.nrows)) instead — Jon Clements
– Jon Clements, Commented May 14, 2013 at 14:26
Yes, Encoding issue occurs. I need to get rid of this because I need to send this value (as float or integer) to another program. That 'u' makes problem for this — ahadcse
– ahadcse, Commented May 14, 2013 at 15:41
You'll get unicode when the entries are strings in the sheet, if they're numeric, you'll get them as floats... so could you elaborate on the exact problem you're having? — Jon Clements
– Jon Clements, Commented May 14, 2013 at 15:55

alecxe · Accepted Answer · 2013-05-14 14:24:44Z

1

The 'u' is not part of the string, it comes before the quotes and indicates a unicode string, which should be fine.

Also, you may want to have a look at the more recent openpyxl.

edited May 14, 2013 at 14:24

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

answered May 14, 2013 at 14:23

wich

17.2k6 gold badges51 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

taking data from .xls file to python list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related