Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
3338 Ansichten

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".

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
4
Mai 24
2762
3
Nov. 23
7297
1
Dez. 21
4524
1
Jan. 19
3382
1
März 15
511