Need guide on how to use the "Excel Tools" downloaded plugin. It has been uploaded from Admin Console. But the read me document does not mention the syntax or Parse Excel Spreadsheet to CDT smart service name to use in expression rules. No examples found for this. Please advise?
Discussion posts and replies are publicly visible
@anushas0002: AFAIK Please find below ones.
Please find below things for how to use the Parse Excel To CDT .1. Please make sure your excel should like this .
2. Please find below Screen Shot for configure the Smart Service.
3. Please find Screen shot for Out Put Configurations.
1. Please make sure sheet number [Delete Hidden sheet] otherwise will give exception error.
2. Please make sure configure row and Column properly.
I hope it will help!!
Thanks!!
Hi Venkat, I am getting an error as below. Please advise on how to fix it or if anything wrong in the way the sheet number is being passed. It is a Number(integer) type and passed 1 as the sheet name given was 1 in excel file. Please refer to the attached screenshots. ???Sheet index (1) is out of range (0..0)???
Hi anushas0002 ,
You can try the below way