SQL Export Excel

sql_export_excel · OCA/reporting-engine

    Repository
    OCA/reporting-engine · module folder · Try on Runboat
    Module version
    1.0.1
    Category
    Generic Modules/Others
    Folder size
    0.05 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/reporting-engine
    Last tracking update
    2026-08-07 08:43:02
    Authors
    Akretion, Odoo Community Association (OCA)
    Maintainers
    Akretion, Odoo Community Association (OCA)
    Committers
    Florian da Costa, OCA-git-bot, oca-ci
    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
    openpyxl
    System dependencies
    None
    Required by
    None
    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 IDNameModelTypeStatus
    sql_export_excel_view_form sql.export form 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)

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Status
    Open migration PR — not merged yet for this version
    CI status
    checks failing
    Open since
    29 days ago
    Last activity
    29 days ago
    Repository
    OCA/reporting-engine
    Pull request
    [19.0][MIG] sql_export_excel: Migration to 19.0 (#1181)