Description

Writes specified values to a specified range in Excel file.

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

Parameters

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.

    

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,

   {"My List": [{Country: "Russia", Capital: "Moscow"}, {Country: "USA", Capital: "Washington DC"}]}

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.

    

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.

    

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.

    

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.

    

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