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	2498
Clients queue system 8.0	7 9月 20	7300
ODOO 12 how can we generate Excel report 已解決 excel	7 1月 24	15113
odoo 8.0 crash after update crm module 8.0	1 11月 17	3944
how to write an excel file into a field who is a field.Binary()? excel	0 2月 17	3166

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！