Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3 Odpovědi
7395 Zobrazení

 I want to write a module which gets an excel file as input and do some process based on excel data. How can I achieve this? Thanks in advance.

Avatar
Zrušit
Autor

I also don't want to save it in database.

Nejlepší odpověď

This is mostly related to python and not Odoo. If you just google, you will get lots of options and code to read the data from excel.

https://www.geeksforgeeks.org/reading-excel-file-using-python/
https://datatofish.com/read_excel/

For the input, create a wizard and add a binary field in which you can load the excel file, and then using any python library, you can read the data from that excel.



Avatar
Zrušit
Autor

Can you be more specific about odoo part?

You need to create a wizard and a binary field to take the file as an input and then using python lib, read the data from the file.

Autor

and How can I process the file that I uploaded?

Nejlepší odpověď

Instead of coding I have started using android productivity office apps. Microsoft 365 is the best solution.

Avatar
Zrušit
Nejlepší odpověď

Hi,

To load an excel file and read its data and to create record inside the odoo database, you can refer this module, which creates chart of account from excel. See this: Import Chart of Accounts from CSV or Excel File

Relevant part of the code, that reads data from excel.

try:
fp = tempfile.NamedTemporaryFile(delete=False, suffix=".xlsx")
fp.write(binascii.a2b_base64(self.File_slect))
fp.seek(0)
values = {}
workbook = xlrd.open_workbook(fp.name)
sheet = workbook.sheet_by_index(0)
except:
raise Warning(_("Invalid file!"))

for row_no in range(sheet.nrows):
val = {}
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, bytes) and row.value.encode('utf-8') or str(row.value),
sheet.row(row_no)))

values.update({'code': line[0],
'name': line[1],
'user': line[2],
'tax': line[3],
'tag': line[4],
'group': line[5],
'currency': line[6],
'reconcile': line[7],
'deprecat': line[8],
})

res = self.create_chart_accounts(values)

Thanks

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
3
lis 20
4932
2
srp 22
6400
4
kvě 24
2867
2
říj 23
3448
1
pro 21
4637