Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I have an excel file as below:
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
_name = 'punch.task'
_description = 'Punch task'
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".
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/10/16, 6:08 AM|
|Seen: 456 times|
|Last updated: 7/10/16, 11:26 AM|