To enter the data in the Excel table into the Clipboard in the same format;
- Excel file is opened and dataset is output.
- With the Get Action component, Tax No, Year and Amount information is retrieved from the dataset.
- 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);