Description
Writes specified values to a specified range in Excel file.
Studio Pro supports Microsoft Excel .xls and .xlsx document formats.
Parameters
-
Set a value: enables you to directly write the desired path. Clicking the 'Pick' button allows you to manually choose the path.
-
Save the previous step result: chooses the previous activity result as a path.
-
Calculate a value: enables you to use available properties and methods to form a path.
-
Save the previous step result: chooses the previous activity result as the data.
-
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"}]
Allows you to specify a start row for writing.
-
Set a value: enables you to directly write the desired number of the start row.
-
Save the previous step result: chooses the previous activity result as a number of the start row.
-
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.
-
Set a value: enables you to directly write the desired Excel column index of the start column.
-
Save the previous step result: chooses the previous activity result as Excel column index of the start column.
-
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.
-
Set a value: enables you to directly specify the sheet name, for example,
Employees
. -
Save the previous step result: chooses the previous activity result as the sheet name.
-
Calculate a value: enables you to use available properties and methods to form the sheet name.
The default method is "Auto".
-
Use table headers: select this option if the header contains of words specified by the user (see the example above).
-
Use column letters: select this option if the header contains of the standard 'Excel' column names: 'A', 'B', 'C' and so on.
-
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.
Note. This activity doesn't change the formatting of Excel-table.