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

  Discussion posts and replies are publicly visible

Parents
  • You should be able to come up with a function that does all this for a single line and returns your desired data type. Then use this in a reduce() call creating a list of your CDT. But depending on the length of the file this will take a while.

    Why do you want all this on one form? Just submit it, do the conversion in a script task and return to the same form showing the data and errors.
Reply
  • You should be able to come up with a function that does all this for a single line and returns your desired data type. Then use this in a reduce() call creating a list of your CDT. But depending on the length of the file this will take a while.

    Why do you want all this on one form? Just submit it, do the conversion in a script task and return to the same form showing the data and errors.
Children
No Data