Skip to Content
This question has been flagged
excelwizzard8.0
3 Replies
17830 Views
Avatar
Rachid

Hello

I would like to import some line with a wizzard, I defined a fields.benary

I can't read the file with

workbook = xlrd.open_workbook

I get this error:

File "/usr/lib/python2.7/dist-packages/xlrd/__init__.py", line 394, in open_workbook f = open(filename, "rb")

IOError: [Errno 36] File name too long: '0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAOwAD

 

Avatar
Discard
Avatar
Rachid
Author Best Answer

answer:

imported=self.browse(cr, uid, ids, context=context)[0]
file_path = tempfile.gettempdir()+'/file.xls'
data = imported.file_import
f = open(file_path,'wb')
f.write(data.decode('base64'))
f.close()
workbook = xlrd.open_workbook(file_path)

Avatar
Discard
Avatar
Bryan Sandoval
Best Answer

from xlrd import open_workbook

import base64

file = fields.Binary(string='Xls file', required=True)

 def fct(self):

...

...

file_data = base64.b64decode(self.file)

wb = open_workbook(file_contents=file_data)

sheet = wb.sheet_by_index(0)

values = sheet._cell_values

Avatar
Discard
Avatar
Abdessamad HILALI
Best Answer 
from xlrd import open_workbook


file = fields.Binary(string='Xls file', required=True)
 
def fct(self):
...
...
file_data = self.file.decode('base64')
wb = open_workbook(file_contents=file_data)


Avatar
Discard
Related Posts Replies Views Activity
Cant download excel data from v11 using chrome anymore Solved
excel
Avatar
Avatar
1
Nov 22
1507
Clients queue system
8.0
Avatar
Avatar
7
Sep 20
5993
ODOO 12 how can we generate Excel report Solved
excel
Avatar
Avatar
Avatar
Avatar
7
Jan 24
13937
odoo 8.0 crash after update crm module
8.0
Avatar
Avatar
1
Nov 17
2746
how to write an excel file into a field who is a field.Binary()?
excel
Avatar
0
Feb 17
2301