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.
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
AanmeldenGerelateerde posts | Antwoorden | Weergaven | Activiteit | |
---|---|---|---|---|
|
2
jul. 25
|
4709 | ||
|
2
dec. 24
|
7832 | ||
How to ORDER BY? [Odoo 10]
Opgelost
|
|
2
nov. 24
|
28621 | |
|
2
mei 24
|
7545 | ||
|
3
mrt. 24
|
6976 |