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)

Bài viết liên quan	Trả lời	Lượt xem
Cant download excel data from v11 using chrome anymore Đã xử lý excel	1 thg 11 22	2509
Clients queue system 8.0	7 thg 9 20	7306
ODOO 12 how can we generate Excel report Đã xử lý excel	7 thg 1 24	15133
odoo 8.0 crash after update crm module 8.0	1 thg 11 17	3950
how to write an excel file into a field who is a field.Binary()? excel	0 thg 2 17	3172

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!