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