I have a binary field that holds my excel file and I need to read the data from it. I need to get the data as rows. How can I achieve this?
Can anyone help?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
2
Antwoorden
5178
Weergaven
I got the answer.
Use xlrd to read the file as given below.
from xlrd import open_workbook
import base64
wb = open_workbook(file_contents = base64.decodestring(obj.file))
sheet = wb.sheets()[0]
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
1
dec. 18
|
3093 | ||
|
2
okt. 18
|
7942 | ||
|
1
dec. 16
|
7497 | ||
|
2
nov. 16
|
6310 | ||
|
1
aug. 16
|
4018 |
Well, I have faced the same issue
https://www.odoo.com/forum/help-1/question/how-to-import-xls-data-into-binary-field-in-odoo-10-using-a-two-dimensional-list-112749