Skip to main content

What can we help you with?

Search

Write Excel Range

Ivan Kuznetsov
  • Updated

Description

Writes specified values to a specified range in an 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 previous activity result as the data.

  2. Calculate a value: enables you to use available properties and methods to form a table. For example, [{Country: "Russia", Capital: "Moscow"}, {Country: "USA", Capital: "Washington DC"}]

 
From Row

Allows you to specify a start row for writing.‌

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

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

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

     

From Column

Allows you to specify a start column for writing.‌

  1. Set a value: enables you to directly write the desired Excel column index of the start column.

  2. Save the previous step result: chooses the previous activity result as Excel column index of the start column.

  3. Calculate a value: enables you to use available properties and methods to form Excel column index of the start column.

     

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 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 doesn't change the formatting of Excel-table.

Related articles