Skip to main content

What can we help you with?

Update Excel Row

Ivan Kuznetsov
  • Updated

Description

Updates particular row values in the Excel file.

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 the machine and provides higher efficiency and stability with different types of files.

Generic does not require Excel to be installed, but it may be less efficient and stable.

 

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.

     

Value

  1. Save the previous step result: chooses the last result activity as the data.

  2. Calculate a value: enables you to use available properties and methods to form a data for the row. For example, {{Col1: "1", Col2: "2"}, {Col1: "3", Col2: "4"}} or [1, 2, 3], [4, 5, 6]

 
Row number

Allows you to specify a row for updating.‌

  1. Set a value: enables you to directly write the desired number of the row.

  2. Save the previous step result: chooses the previous activity result as a number of the row.

  3. Calculate a value: enables you to use available properties and methods to form a number of the row.

     

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 of words specified by the user (see the example above).

  2. Use column letters: select this option if the header contains of 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 does not change the formatting of the Excel table.

Related articles