Skip to content

Write Data-list to Excel File

Description

The write data-list to excel file command will take any data-list and write to an excel file starting from cell A1.

Input Ports

Name dataType sourceType required description
Header options text manual-only true Allows you to write the fields as headers, remove the headers completely or keep the existing header values of the file and just write the values
Fields data-field link-manual true Fields are the header values that will be written to the first row of the sheet when the header option is write headers, the fields must be the same as the data-items of the data-list provided
File path text link-manual true The path to the excel file you want to write to
Worksheet name text link-manual true The sheet name inside of the excel file you want to target
Data rows data-list link-manual true The data-list you want to write to the file

Use cases

  • The user has a data-list that contains anything and wants to write the values inside of the data-list to an excel file.
  • The user has a data-list that contains anything and wants to write values without the headers to an excel file.
  • The user has a data-list that contains anything and wants to keep the current headers in the excel file and just write the data-list values to the excel file.

What does the header options do

Type Description
Write headers The fields you specified will be written as the first row in the excel spreadsheet
No headers This will remove what ever is inside of the first row and overwrite it with the values inside the data-list
Skip headers This will keep what ever is inside of the first row and write the values inside the data-list starting from cell A2

Use case

Command

Inputs
  • Header options: Write headers
  • Fields: name, text; surname, text;
  • File path: C:/Users/admin/Desktop/example.xlsx
  • Sheet name: Sheet1
  • Data rows:
    Command
Experienced tips
  • If the file path value is empty, the process will stop and provide you with this error Excel file path is required
  • When the file path cannot be found, the file will be created at the specified path with the file name specified with the path
  • When the sheet name cannot be found, the sheet name will be created throught the process
  • When the headers are there but there are no values underneath the headers, make sure that your Fields and data-items inside of your Data rows are the same
Output

Output

Search Tags

write values to excel