How to read Excel file ?

Question

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/

Rachid · Accepted 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)

Bryan Sandoval · 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

Abdessamad HILALI · 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)

Related Posts	Відповіді	Переглядів
Cant download excel data from v11 using chrome anymore Вирішено excel	1 лист. 22	2507
Clients queue system 8.0	7 вер. 20	7305
ODOO 12 how can we generate Excel report Вирішено excel	7 січ. 24	15131
odoo 8.0 crash after update crm module 8.0	1 лист. 17	3950
how to write an excel file into a field who is a field.Binary()? excel	0 лют. 17	3172

Це запитання позначене

Enjoying the discussion? Don't just read, join in!