ExportToXLSX
Exports context data to a Microsoft Excel Open XML Spreadsheet (XLSX) file.
python · Common Scripts
Details
| ID | ExportToXLSX |
|---|---|
| Language | python |
| From Version | 6.5.0 |
| Docker Image | demisto/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