跳至內容
此問題已被標幟
importexcelopenerp
2 回覆
13165 瀏覽次數
頭像
Zahin

Hello,

I want to import excel file in openerp how to ?

I have binary field where I have save excel file. now button click I want to import data from excel to field which in my form view.

I need to parse excel and convert to dict then will do write.

but any good feature with in openerp?

Thanks.

頭像
捨棄
頭像
Borni DHIFI
最佳答案

Hi,

see this topice Read Excel files from Python

頭像
捨棄
頭像
Alexander
最佳答案

You can define on_cnange method, what would process uploaded file. 

<field name="excelfile" on_change="on_file_load(excelfile)"/>

You need to write parsing method in your *.py file

def on_file_load(self, cr, uid, ids, excelfile, context=None):
    #do_something

In this case file would be parsed before you save object.

頭像
捨棄
Zahin
作者

Have you fixed already this, because this will gives base64 encode file.

Alexander

Try to use something like that. 

excelfile = base64.decodestring(excelfile)

And don't forget make 

import base64
Zahin
作者

I have try

base64.decode(lead.data, open("newcsv.xls", "w")) workbook = xlrd.open_workbook("newcsv.xls")

but got traceback AttributeError: 'str' object has no attribute 'readline'

相關帖文 回覆 瀏覽次數 活動
large Purchase Order excel import
import excel purchase_order
頭像
頭像
頭像
頭像
頭像
4
5月 24
2969
OdooV13 write a module to get an excel file as input 已解決
import excel odooV13
頭像
頭像
頭像
頭像
3
11月 23
7512
Upload excel and import to sale order line 已解決
import sale.order.line excel
頭像
頭像
1
12月 21
4777
Import products from excel 已解決
product import excel
頭像
頭像
1
1月 19
3527
V9.0: How shall I select and show some items from Excel Files?
import column excel
頭像
0
7月 16
3554