Skip to main content

What can we help you with?

Search

Append row to Excel file

Ivan Kuznetsov
  • Updated

Description

Adds a row to the end of an Excel sheet.

Studio Pro supports Microsoft Excel .xls and .xlsx file formats.

As of the 8.3 update, there are two ways of interacting with MS Excel - Microsoft Native and Generic. Navigate to the menu "Settings"  → "Microsoft Activities" to choose a method.

Microsoft Native uses standard Microsoft methods to interact with the Excel application. It requires Excel to be installed on your computer and extends the capabilities of interacting with all Excel functionalities.
Generic does not require Excel to be installed and may have some Excel functionalities limitations.

 

Parameters

Path

  1. Set a value: enables you to directly write the desired path. Clicking the 'Pick' button allows you to manually choose the path.

  2. Save the previous step result: chooses the previous activity result as a path.

  3. Calculate a value: enables you to use available properties and methods to form a path.

 
Row to append

  1. Save the previous step result: chooses the previous function result as the row.

  2. Calculate a value: enables you to use available properties and methods to form the row. The format must be one of the following:

  • {"Column 1": "Value 1", "Column 2": "Value 2", "Column 3": "Value 3"}. For example,

    {"Name": "Michael", "Last Name": "Smith", "Age": 30}

  • ["Value 1", "Value 2", "Value 3"]. For example, ["Michael", "Smith", 30].

 
Excel sheet name

By default, the first sheet in an Excel file is used.

  1. Set a value: enables you to directly specify the sheet name, for example, Employees.

  2. Save the previous step result: chooses the previous activity result as the sheet name.

  3. Calculate a value: enables you to use available properties and methods to form the sheet name.

     

Get dictionary key

The default method is "Auto".

  1. Use table headers: select this option if the header contains words specified by the user (see the example above).

  2. Use column letters: select this option if the header contains the standard 'Excel' column names: 'A', 'B', 'C', and so on.

  3. Auto: select this option to define a header by the input data automatically

     

Comment

Contains an annotation of the activity. The input text will be displayed above the activity name.

 

Note. This activity adds information to Excel without formatting. 

 

Related articles