I have excel sheet in which some rows are empty , I need to show the user in a message box that imported excel sheet has empty rows giving particular row number which is empty or some data/field in the rows are empty . I need to display the message box for this Usecase also . But I am unable to show the rows number along with the field/ data which is empty from my excel sheet while importing . Please guide me through this
Make sure you select the import action Create objects (for every row).
Following you can validate all objects that have been created as a result of an Excel import.
You can use an Integer variable named Row that you can increase every iteration when you loop over the list of objects.
The Row value you can then include in the validation message.