You can find the functionality implemented in UI Map 'F1-BundleExportMaintenance'.
You can access this maintenance map from Admin -> b -> Bundle Export.
notice the oraUploadData function implemented on the UI Map HTML
<input class="oraButton" oraMdLabel="F1_CSVFILEUPLOAD_LBL" oraUploadData="type:popup;path:boGroup/entities"/>
The columns in upload csv file would be mapped to "boGroup/entities" list node
you might want to download a sample csv file first (using the same list) which you can reuse for upload.
Thanks for your reply. Yes my scenarios both cases 1 and 2.
It should import data from xls/xlsx sheet and also invoke ServiceScript and populate the values to the field in the UI map and then save the record and then perform some based on the cell value in the xls sheet, such as verifying some element value on the display map.
If your are able to convert XLS file into CSV file, then use oraUploadData methodology to load content of CSV file into your UI map schema. Then after process the comma separated values and invoke the SS/Button Action/etc...
Else, keep the xls files in designated directory within server(where the application is installed). On click of button in ur UI map, display the list of xls file name and let the user to select the particular file. Process the selected xls file in the service program with selected xls file. Now the service program has all the cell values and you can perform the validations and then return the validated cell values to the UI map schema. Based on the values invoke the SS/any action....