Hi Jhansi
You need to create a duplicate the entity which you need to import the data and name as ExcelImport, Use ExcelImport Entity for importing Excel file and Retrieve the above entity and iterate and check for validations, once the validation passed create the object in your entity where you want the data and add to list and finally the commit the list outside the loop.
Kindly reply if any doubts ..
One approach could be to have a boolean attribute called something like isNew in the entity with a default value of true. When the data is imported this value will automatically be true. Once you've validated the data, set this value to false. So to look for the new data, just search for those objects with isNew set to true.
I hope this helps.
After successfully importing the Excel file, extract the rows or objects using the pandas or openpyxl libraries for subsequent data validation.
Thanks everyone for responding, But fortunately I found the simple solution by providing the reference object in the java action we can retrieve from the object which is provided as reference. Its mendix provided functionality.