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.
Posted: 5 years ago
Posted: 7 Feb 2017 20:34 EST
Smit Prakash Prajapati (SMITACC11)