HI All,
Can someone tell me how to use readexcelsheet() function, i am trying to use this on button click in interface in a!save() , it is not working properly .
Thanks,
Bhargavi
Discussion posts and replies are publicly visible
Hi bhargavii0001 ,
I have tried extracting the values from excel using readexcelsheet and saved into rule input.
Please find below code for reference
here ri!sampleTest is AnyType ruleinput
a!save( ri!sampleTest, readexcelsheet( excelDocument: todocument( 3970 ), sheetNumber: 0, startRow: 0 ) )
The output structure of readexcelsheet is like
{ Success: boolean, result: { Values: row1Values, values: row2Values } }
Regards,
Sachin
Hi bhargavip0001 ,
From 17.X version When a file is uploaded, the file component updates with a temporary Document representing the uploaded file. which has permanent document id and you can use that document id in the readexcelsheet for validation before form submission.
For more details follow this link