How xlrd stores data from excle sheet via sheet.row() or sheet.col()

ساخت وبلاگ

آخرین مطالب

امکانات وب

Vote count: 0

I was writing a function importing data from excle sheet

def get_data_excel(path,sheet):
book=xlrd.open_workbook(path)       #opens the excle document
sheet=book.sheet_by_index(sheet-1)  #def. the sheet where the data are stored
nocol=5
data=[list() for f in range(nocol)] #creating a empty list where all collumns are stored as lists
for j in range(nocol):              #filling the emty lists in the list data
        data[j]=sheet.col(j)
return data

This returns a list-list like this: [[text:'Oxygen', number:17, number:13],[text:'Nigrogen', number:12, number:10],...]

Question: I was wondering, why it does that and how to use the lableing of the date. E.g. to get only the text from the list or only number...?

thx maths

asked 1 min ago
Matthias K

...
نویسنده : استخدام کار بازدید : 37 تاريخ : چهارشنبه 23 خرداد 1397 ساعت: 17:41

close
تبلیغات در اینترنت