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)

관련 게시물	답글	화면
Cant download excel data from v11 using chrome anymore 해결 완료 excel	1 11월 22	2675
Clients queue system 8.0	7 9월 20	7511
ODOO 12 how can we generate Excel report 해결 완료 excel	7 1월 24	15312
odoo 8.0 crash after update crm module 8.0	1 11월 17	4094
how to write an excel file into a field who is a field.Binary()? excel	0 2월 17	3395

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!