i can set values in a Spreadsheets from a pivot view,
but how can i get the value of a Spreadsheet from python or javascript?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
i can set values in a Spreadsheets from a pivot view,
but how can i get the value of a Spreadsheet from python or javascript?
Short answer YES!!!
Spreadsheets are stored in model ir.attachment
Data sits in the binary field called datas.
If you download the binary file you will see that its just test in json format like below:
{
"version": 5,
"sheets": [{
"id": "a396ebcb-f98f-4fb9-8b70-25590191a586",
"name": "Sheet1",
"colNumber": 26,
"rowNumber": 100,
"rows": {},
"cols": {},
"merges": [],
"cells": {
"A1": {
"content": "sdfsdf"
},
"A2": {
"content": "dfsf"
},
"A3": {
"content": "sdfs"
},
"A4": {
"content": "sfsfs"
}
},
"conditionalFormats": [],
"figures": []
}, {
"id": "488f782f-eac3-48a0-98b9-a2d55bf08acd",
"name": "Sheet2",
"colNumber": 26,
"rowNumber": 100,
"rows": {},
"cols": {},
"merges": [],
"cells": {
"C2": {
"content": "sff"
}
},
"conditionalFormats": [],
"figures": []
}],
"activeSheet": "488f782f-eac3-48a0-98b9-a2d55bf08acd",
"entities": {},
"styles": {
"0": {
"fillColor": "white",
"textColor": "black",
"fontSize": 11
}
},
"borders": {},
"pivots": {},
"globalFilters": []
}
From python you can get to the datas field and read/manipulate the data on the spreadsheet.
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 | |
---|---|---|---|---|
|
0
Mai 24
|
5 | ||
|
0
Feb. 24
|
893 | ||
|
1
Juli 25
|
310 | ||
|
0
Mai 24
|
1453 | ||
|
0
Sept. 22
|
1893 |