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!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
2
Juli 25
|
6880 | |||
|
2
Okt. 25
|
8995 | |||
|
How to ORDER BY? [Odoo 10]
Gelöst
|
2
Nov. 24
|
29917 | ||
|
2
Mai 24
|
8548 | |||
|
3
März 24
|
7970 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.