Module: sql_export_excel - Odoo Module Metadata

TIP: You can type at any time to perform a new search.

SQL Export Excel

sql_export_excel

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/18.0/sql_export_excel
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Florian da Costa, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:30:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - spreadsheet_dashboard - spreadsheet - bus - base - web - portal - web_editor - html_editor - http_routing - mail - base_setup - web_tour - auth_signup
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	Add the possibility to extract data from a sql query toward an excel file. It is also possible to provide an template excel file for a query. In this case, the data will be inserted in the specified sheet of the provided excel file. This is usefull when doing a lot of calculation in excel and the data is coming from Odoo.

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
ondelete={'excel': 'set default'} selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/17.0/sql_export_excel
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, Marius
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:20:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - spreadsheet_dashboard - spreadsheet - bus - base - web - portal - web_editor - http_routing - mail - base_setup - web_tour - auth_signup
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	Add the possibility to extract data from a sql query toward an excel file. It is also possible to provide an template excel file for a query. In this case, the data will be inserted in the specified sheet of the provided excel file. This is usefull when doing a lot of calculation in excel and the data is coming from Odoo.

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
ondelete={'excel': 'set default'} selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/16.0/sql_export_excel
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Florian da Costa, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:53:57
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - spreadsheet_dashboard - spreadsheet - bus - base - web - mail - base_setup - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
ondelete={'excel': 'set default'} selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/15.0/sql_export_excel
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	OCA Transbot, Weblate, OCA-git-bot, oca-ci, Maksym Yankin
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:46:42
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
ondelete={'excel': 'set default'} selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/14.0/sql_export_excel
VERSION
VERSION	1.1.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Enric Tobella, OCA Transbot, oca-travis, Weblate, OCA-git-bot, hkpatel
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:41:05
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_export - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
ondelete={'excel': 'set default'} selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/12.0/sql_export_excel
VERSION
VERSION	1.1.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Sylvain LE GAL, GitHub, Florian da Costa, oca-travis, OCA-git-bot, Tom Blauwendraat
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:29:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_export - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	openpyxl
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_excel_view_form`		sql.export	field	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (6)

attachment_id Many2one → ir.attachment
help='If you configure an excel file (in xlsx format) here, the result of the query will be injected in it.\nIt is usefull to feed data in a excel file pre-configured with calculation' string='Excel Template' args: 'ir.attachment'
col_position Integer
default=1 help='Indicate from which column the result of the query should be injected.' string='Column Position'
file_format Selection
selection_add=[('excel', 'Excel')]
header Boolean
default=True help='Indicate if the header should be exported to the file.'
row_position Integer
default=1 help='Indicate from which row the result of the query should be injected.'
sheet_position Integer
default=1 help="Indicate the sheet's position of the excel template where the result of the sql query should be injected."

Public methods (4)

check_column_position(self)
@api.constrains('col_position')
check_row_position(self)
@api.constrains('row_position')
check_sheet_position(self)
@api.constrains('sheet_position')
excel_get_data_from_query(self, variable_dict)
@api.multi

STATUS
STATUS	Open migration PR - not merged yet for this version
REPOSITORY
REPOSITORY	OCA/reporting-engine
PULL REQUEST
PULL REQUEST	[19.0][MIG] sql_export_excel: Migration to 19.0 (#1129)

SQL Export Excel

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 6 fields 4 methods SqlExport · inherits sql.export