Question regarding shared component readexcel file

Hi to everyone,

I am using the shared component readexcel file.

Key users ask us to create a form in whiche end users can upload an excel, you can find it attached.

At this poin in the same form, using the function readexcelsheet(ri!document,0,2) we have:

1- remove all rows that contain only null files,
2-show all row in a readonly grid and save all the value in a multiple cdt with single field, you can find it attached.
3-if the rows saved contains some null values make appear an error message to the users that advise them that some field are null and that, without exiting from this form, make them correct the excel file on their pc and upload it again

Any suggestion on how we can do this

provaRiskManagement2.xlsx

OriginalPostID-213128

OriginalPostID-213128