ExportToXLSX

Exports context data to a Microsoft Excel Open XML Spreadsheet (XLSX) file.

python · Common Scripts

Details

IDExportToXLSX
Languagepython
From Version6.5.0
Docker Imagedemisto/xslxwriter:1.0.0.10120494

README

Exports context data to a Microsoft Excel Open XML Spreadsheet (XLSX) file.

Script Data


Name Description
Script Type python3
Tags  
Cortex XSOAR Version 5.0.0

Inputs


Argument Name Description
file_name The output file name (for example “Report.xlsx”).
data The data to export. Accepts a context key of a dictionary or a list of dictionaries for a single sheet file (${data}). Separate multiple sheet files using a comma “,”. For example, if you are exporting multiple sheet files, the argument would be: ${data1},${data2}.
sheet_name The sheet name. Separate multiple sheet names using a comma “,”, for example, sheet1,sheet2.
headers A comma-separated list of headers. The order that you pass the headers determines how they display in the exported sheet(s). Separated multiple sheets using a semicolon. For example, if you are exporting two sheets that includes two headers each, the argument would be: “header1,header2;header3,header4”.
bold Whether table headers should be bold. If this argument is set to “true”, table headers are bold. Default is “true”.
border Whether borders should be added to table cells. If this argument is set to “true”, borders are added to table cells. Default is “true”.

Outputs


There are no outputs for this script.

args:
- description: The output file name (for example "Report.xlsx").
  name: file_name
  required: true
- description: 'The data to export. Accepts a context key of a dictionary or a list of dictionaries for a single sheet file (${data}). Separate multiple sheet files using a comma ",". For example, if you are exporting multiple sheet files, the argument would be: ${data1},${data2}.'
  isArray: true
  name: data
  required: true
- description: The sheet name. Separate multiple sheet names using a comma ",", for example, sheet1,sheet2.
  isArray: true
  name: sheet_name
  required: true
- description: 'A comma-separated list of headers. The order that you pass the headers determines how they display in the exported sheet(s). Separated multiple sheets using a semicolon. For example, if you are exporting two sheets that includes two headers each, the argument would be: "header1,header2;header3,header4".'
  name: headers
- auto: PREDEFINED
  defaultValue: 'true'
  description: Whether table headers should be bold. If this argument is set to "true", table headers are bold. Default is "true".
  name: bold
  predefined:
  - 'true'
  - 'false'
- auto: PREDEFINED
  defaultValue: 'true'
  description: Whether borders should be added to table cells. If this argument is set to "true", borders are added to table cells. Default is "true".
  name: border
  predefined:
  - 'true'
  - 'false'
comment: Exports context data to a Microsoft Excel Open XML Spreadsheet (XLSX) file.
commonfields:
  id: ExportToXLSX
  version: -1
enabled: true
name: ExportToXLSX
script: '-'
subtype: python3
timeout: '0'
type: python
dockerimage: demisto/xslxwriter:1.0.0.10120494
runas: DBotWeakRole
tests:
- No tests (auto formatted)
fromversion: 6.5.0