hi,
i have uploaded an xls file into a wizard, and how i access the values in the xls file from the BINARY FIELD. please help
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
hi,
i have uploaded an xls file into a wizard, and how i access the values in the xls file from the BINARY FIELD. please help
hello
try like below code
import xlrd
import tempfile
import binascii
@api.multi def your_method(self): fp = tempfile.NamedTemporaryFile(suffix=".xlsx") fp.write(binascii.a2b_base64(self.xls_file)) fp.seek(0) workbook = xlrd.open_workbook(fp.name) sheet = workbook.sheet_by_index(0)
for row_no in range(sheet.nrows): if row_no <= 0: fields = map(lambda row:row.value.encode('utf-8'), sheet.row(row_no)) else: line = list(map(lambda row:isinstance(row.value, str) and row.value.encode('utf-8') or str(row.value), sheet.row(row_no)))
print ("==========",line) # in this line variable you get the value line by line from excel.
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
2
Juli 25
|
4754 | ||
|
2
Dez. 24
|
7868 | ||
How to ORDER BY? [Odoo 10]
Gelöst
|
|
2
Nov. 24
|
28648 | |
|
2
Mai 24
|
7560 | ||
|
3
März 24
|
7001 |