Hi Soumya,
you must require MS-office installed in the resource for reading the excel content.
In case, if you have a excel data in the collection. Then you can alter some piece of codes from "create text file" and "Write text file" to customize cod...
Hi, as mentioned in the below thread, you can use concat for adding '1' at last. otherwise
you can write a simple excel formula in your configuration '=if(len(a1)=10,a1&"1","")' file and place this formula at last column and drag till end of the row...