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
Hi Anusha,
Once go through this file.
5722.2870.Parse_Excel_Spreadsheet_to_CDT_Smart_Service[1].docx
Hi Anshu,
1) Your CDT should have the same column name as available in the excel sheet.
2) You need to mention which sheet number you want to parse into cdt.
3) Mention row number as well from where you want to read the data.
4) provide the CDT, in which you want to parse the data.
Use the below link to download the document mentioning all the above steps with example.
@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