Entering the Data Received from the Excel Table as Text in the Specified Format

FAQ
1

To enter the data in the Excel table into the Clipboard in the same format;

  1. Excel file is opened and dataset is output.
  2. With the Get Action component, Tax No, Year and Amount information is retrieved from the dataset.
  3. With the help of script, it is ensured to put a space between the data as much as TAB.
var a=execution.getVariable("TaxNo");
var t=execution.getVariable("Year");
var c=execution.getVariable("Amount");

var Information= a.concat('\t',t,'\t',c);

execution.setVariable("Information",Information);