Excel Import/Export/Report

• data Binary
  readonly=True string='File'
• name Char
  readonly=True size=500 string='File Name'
• res_ids Char
  readonly=True required=True string='Resource IDs'
• res_model Char
  readonly=True required=True size=500 string='Resource Model'
• state Selection
  default='choose' help='* Choose: wizard show in user selection mode\n* Get: wizard show results from user action' args: [('choose', 'Choose'), ('get', 'Get')]
• template_id Many2one → xlsx.template
  domain=<expr> ondelete='cascade' required=True string='Template' args: 'xlsx.template'

• action_export(self)
• default_get(self, fields)
  @api.model

• attachment_ids Many2many → ir.attachment
  help='You can select multiple files to import.' required=True string='Import File(s) (*.xlsx)' args: 'ir.attachment'
• datas Binary
  readonly=True related='template_id.datas' string='Sample'
• filename Char
  args: 'Import File Name'
• fname Char
  readonly=True related='template_id.fname' string='Template Name'
• import_file Binary
  string='Import File (*.xlsx)'
• res_id Integer
  readonly=True string='Resource ID'
• res_model Char
  readonly=True size=500 string='Resource Model'
• state Selection
  default='choose' help='* Choose: wizard show in user selection mode\n* Get: wizard show results from user action' args: [('choose', 'Choose'), ('get', 'Get')]
• template_id Many2one → xlsx.template
  domain=<expr> ondelete='cascade' required=True string='Template' args: 'xlsx.template'

• action_import(self)
• check_view_init(self, context)
  This template only works on some context of active record
• default_get(self, fields_list)
  @api.model
• get_import_sample(self)

• report_type Selection
  ondelete={'excel': 'cascade'} selection_add=[('excel', 'Excel')]

No public methods.

• domain Char
  string='Search Criterias'
• res_model Char

• action_report(self)
• safe_domain(self, str_domain)

No new fields.

• apply_extra_conditions_to_value(self, field, value, conditions_dict)
• export_xlsx(self, template, res_model, res_ids)
  @api.model
• get_eval_context(self, model, record, value)
  @api.model
• run_aggre_func_dict(self, field)
• run_field_cond_dict(self, field)
• run_field_style_dict(self, field)
• run_style_cond_dict(self, field)

No new fields.

• get_eval_context(self, model=False, value=False)
  @api.model
• get_external_id(self, record)
  @api.model
  Get external ID of the record, if not already exists create one
• import_xlsx(self, import_file, template, res_model=False, res_id=False)
  @api.model
  - If res_id = False, we want to create new document first - Delete fields' data according to data_dict['__IMPORT__'] - Import data from excel according to data_dict['__IMPORT__']

• choose_template Boolean
  default=False string='Allow Choose Template'
• data Binary
  readonly=True string='File'
• name Char
  readonly=True size=500 string='File Name'
• state Selection
  default='choose' help='* Choose: wizard show in user selection mode\n* Get: wizard show results from user action' args: [('choose', 'Choose'), ('get', 'Get')]
• template_id Many2one → xlsx.template
  domain=<expr> ondelete='cascade' required=True string='Template' args: 'xlsx.template'

• default_get(self, fields)
  @api.model
• report_xlsx(self)

No new fields.

• get_openpyxl_styles(self)
  @api.model
  List all syles that can be used with styleing directive #{...}

• csv_delimiter Char
  default=',' help='Optional for CSV, default is comma.' required=True size=1 string='CSV Delimiter'
• csv_extension Char
  default='csv' help='Optional for CSV, default is .csv' required=True size=5 string='CSV File Extension'
• csv_quote Boolean
  default=True help='Optional for CSV, default is full quoting.' string='CSV Quoting'
• datas Binary
  string='File Content'
• description Char
• export_action_id Many2one → ir.actions.act_window
  comodel_name='ir.actions.act_window' ondelete='set null'
• export_ids One2many → xlsx.template.export
  comodel_name='xlsx.template.export' inverse_name='template_id'
• fname Char
  string='File Name'
• gname Char
  help='Multiple template of same model, can belong to same group,\nresult in multiple template selection' string='Group Name'
• import_action_id Many2one → ir.actions.act_window
  comodel_name='ir.actions.act_window' ondelete='set null'
• import_ids One2many → xlsx.template.import
  comodel_name='xlsx.template.import' inverse_name='template_id'
• input_instruction Text
  help='This is used to construct instruction in tab Import/Export' string='Instruction (Input)'
• instruction Text
  compute='_compute_output_instruction' help='Instruction on how to import/export, prepared by system.'
• name Char
  required=True string='Template Name'
• post_import_hook Char
  help='Call a function after successful import, i.e.,\n${object.post_import_do_something()}' string='Post Import Function Hook'
• redirect_action Many2one → ir.actions.act_window
  comodel_name='ir.actions.act_window' domain=[('type', '=', 'ir.actions.act_window')] help='Optional action, redirection after finish import operation' string='Return Action'
• report_action_id Many2one → ir.actions.report
  comodel_name='ir.actions.report' string='Report Action'
• report_menu_id Many2one → ir.ui.menu
  comodel_name='ir.ui.menu' readonly=True string='Report Menu'
• res_model Char
  help='The database object this attachment will be attached to.' string='Resource Model'
• result_field Char
  compute='_compute_result_field'
• result_model_id Many2one → ir.model
  comodel_name='ir.model' help='When use commone wizard, choose the result model' string='Report Model'
• show_instruction Boolean
  default=False help='This is the computed instruction based on tab Import/Export,\nto be used by xlsx import/export engine' string='Show Output'
• to_csv Boolean
  default=False help='Convert file into CSV format on export' string='Convert to CSV?'
• use_report_wizard Boolean
  help='Use common report wizard model, instead of create specific model' string='Easy Reporting'

• add_export_action(self)
• add_import_action(self)
• add_report_menu(self)
• create(self, vals_list)
  @api.model_create_multi
• load_xlsx_template(self, template_ids, addon=False)
  @api.model
• remove_export_action(self)
• remove_import_action(self)
• remove_report_menu(self)
• unlink(self)
• write(self, vals)

• excel_cell Char
  string='Cell'
• field_cond Char
  string='Field Cond.'
• field_name Char
  string='Field'
• is_cont Boolean
  default=False help='Continue data rows after last data row' string='Continue'
• is_extend Boolean
  default=False help='Extend a blank row after filling each record, to extend the footer' string='Extend'
• is_sum Boolean
  default=False string='Sum'
• row_field Char
  help='If section type is row, this field is required'
• section_type Selection
  required=True args: [('sheet', 'Sheet'), ('head', 'Head'), ('row', 'Row'), ('data', 'Data')]
• sequence Integer
  default=10
• sheet Char
• style Char
  string='Default Style'
• style_cond Char
  string='Style w/Cond.'
• template_id Many2one → xlsx.template
  comodel_name='xlsx.template' index=True ondelete='cascade' readonly=True string='XLSX Template'

• create(self, vals_list)
  @api.model_create_multi

• excel_cell Char
  string='Cell'
• field_cond Char
  string='Field Cond.'
• field_name Char
  string='Field'
• no_delete Boolean
  default=False help='By default, all rows will be deleted before import.\nSelect No Delete, otherwise'
• row_field Char
  help='If section type is row, this field is required'
• section_type Selection
  required=True args: [('sheet', 'Sheet'), ('head', 'Head'), ('row', 'Row'), ('data', 'Data')]
• sequence Integer
  default=10
• sheet Char
• template_id Many2one → xlsx.template
  comodel_name='xlsx.template' index=True ondelete='cascade' readonly=True string='XLSX Template'

• create(self, vals_list)
  @api.model_create_multi