Question
Highmark
US
Last activity: 8 Mar 2017 13:54 EST
How to Read excel sheet
I have a requirement where I need to get pzinskey as mentioned in excel sheet and open the work item in XML form. Please let me know if any one has an idea on this.
***Updated by moderator: Lochan to update Categories***
Accepted Solution
Highmark
US
Thanks Mahesh !.but I did in another way by create Parse delimited rule and mapping the properties to the pagelist.
Pegasystems Inc.
US
Hi Smita,
If you want to read the data from the excel file then you need to use the Apache POI Api refer here.
Probably you can try the code explained by Pereraj in the last comment of this article over here.
Once you read the pzInsKey column value from the excel spreadsheet then you can load the object into the clipboard using Obj-Browse or Obj-Open-By-Handle methods. Hope this might be helpful in proceeding further with your requirement.
Note: Once the Apache poi related jars are imported then you can refer the apache poi documentation to get the code for reading the column values from spreadsheet as shared above.
Regards
Mahesh
Accepted Solution
Highmark
US
Thanks Mahesh !.but I did in another way by create Parse delimited rule and mapping the properties to the pagelist.