I have an excel file as below:
ID | Name | Time001 |
001 | Bob | 2016-05-10 10:40:43 |
002 | John | 2016-06-10 12:32:45 |
... | ... | ... |
Now I want to import this data from this excel file and select some rows and show on Odoo; I have code as below:
# -*- coding: utf-8 -*-
from openerp import models, fields
import base64
class PunchTask(models.Model):
_name = 'punch.task'
_description = 'Punch task'
datafile=fields.Binary("File")
records=fields.Text('Selected Items')
def action_upload(self,cr,uid,ids,context=None):
this=self.browse(cr,uid,ids[0])
data = base64.decodestring(this.datafile)
Then the "Datafile" can get selected Excel file and "data" can get data from the excel file;
My question is: how can I get each column's data from "data" like this:
column_1=['001','002','...']; colume_2=['Bob','John','...'];column_3=['2016-05-10 10:40:43','2016-06-10 12:32:45','...'];
Finally I want to select the rows whose "Time" is " 2016-05-10 10:40:43" or other something; and how the rows on "records".