Table of Contents

Connections

Commands

Connections

Microsoft Excel

Collection of functions for Microsoft Excel workbooks

Inputs

None

Commands

Create Workbook from Files

Creates an Excel workbook from a list of CSV files

Inputs

Input

Type

Detail

Notes

Files

GroupField

List of CSV files used to populate an Excel workbook. Each file will create a sheet in the workbook.

If you choose to provide the inputs as JSON, a list of JSON objects can be provided to this command in the following format: [{"file": "file.csv", "name": "Sheet1"}]

Delimiter

DropdownField

Delimiter of the provided files

Workbook Name

TextField

Name of the Workbook file that will be created (optional)

The file will be created with the .xlsx extension if it is not providded

Existing Workbook

FileField

Write the CSV data to an existing workbook. Any conflicts in sheet names will overwrite the existing sheet(s).

Outputs

Output

Output Type

Notes

XLSX Workbook

File

Exit Codes

Code

Type

Detail

0

Success

Command succeeded

1

Error

General failure

List Sheets

Finds all sheets in an Excel workbook (XLS or XLSX)

Inputs

Input

Type

Detail

Notes

Workbook File

FileField

XLSX or XLS workbook

Password

TextField

If your XLSX file is password protected, enter the password here. NOTE: Only XLSX files are supported

Outputs

Output

Output Type

Notes

Sheets JSON

File

Exit Codes

Code

Type

Detail

0

Success

Command succeeded

1

Error

General failure

Worksheet to CSV

Converts a worksheet in an Excel workbook (XLSX or XLS) to a tabular file

Inputs

Input

Type

Detail

Notes

Workbook File

FileField

XLSX or XLS workbook

Password

TextField

If your XLSX file is password protected, enter the password here. NOTE: Only XLSX files are supported

Delimiter

DropdownField

Output CSV delimiter

Sheet Name

TextField

Name of the sheet in the Excel workbook to be converted to a CSV. Only provide a value here if you have not specified a Sheet Index.

This value is optional if you specify a Sheet Index

Sheet Index

NumberField

Index of the sheet in the Excel workbook to be converted to a CSV. The first sheet in the workbook is specified with an index value of 1, and the last with -1. Only provide a value here if you have not specified a Sheet Name.

This value is optional if you specify a Sheet Name

Start Cell

TextField

The cell in the sheet that the CSV data starts at. This will be the cell in both the first row and the first column of data.

End Column

TextField

Specify and end column letter using A1 notation. All data after this column letter will be excluded. You should not include the row number. (Examples: A, B, C, D)

End Row

NumberField

Specify and end row using A1 notation. All data after this row number will be excluded. If you specify 0, this will be ignored. You should not include the column letter. (Examples: 10, 200, 3000)

Use Formatted Cell Values

BooleanField

If checked the display value in each cell will be used to produce the CSV data rather than the raw cell value.

Preview

BooleanField

Preview the results of the created CSV data

Outputs

Output

Output Type

Notes

Output CSV

File

Exit Codes

Code

Type

Detail

0

Success

Command succeeded

1

Error

General failure

Did this answer your question?