Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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)
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
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)
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
1
Nov. 22
|
2506 | ||
|
7
Sept. 20
|
7305 | ||
|
7
Jan. 24
|
15130 | ||
|
1
Nov. 17
|
3949 | ||
|
0
Feb. 17
|
3171 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
