when user upload any kind of excel sheet then interface will extract data and show the user the data.
I have created a Expression rule
readexcelsheetpaging(excelDocument : todocument(ri!ExtratExcel), sheetNumber : 0,pagingInfo:a!pagingInfo(startIndex:1,batchSize:1000),)
but don't know how to add it in script task and make process model out from this.
Discussion posts and replies are publicly visible
In the script task, go to the output node. In this node, you can assign custom values to your process variables.
In the value, call this expression rule using the rule! domain and pass your document type process variable in the 'ExtractExcel' rule input of the rule.
Next, in the save into of the output variable, create a new variable that will be of type DataSubset.
This is how you call in the process. Or, another way is to let the user upload the document on one screen, and in the same process, add another UIT and chain them together and call this rule on the second interface mapped as the UIT.