readexcelsheet function

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 Sachin,

thanq , but i was not knowing that i can read only documents which are saved in Appian

You can also read the files uploaded by the user, but you need to submit the form, so that the file will be saved in the folder and do the rest of the things as said earlier.

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

 

Regards,

Sachin

I think this won't work, still the form needs to be submitted( document needs to be saved in the directory)

Hi , can u tell me how to access that temporary file i couldn't find something like that in the link which u provided

Hi bhargavip0001 ,
I have tried it somehow it is not possible i think the smart service is not able to access the temporary document folder where the document is stored the other way around is, let the user upload the file and let him click on submit button after submit extract the data from the excel sheet and perform the validation in process model if some validation error occurs then redirect to form again with error message.

Hi bhargavip0001 ,
I have tried it somehow it is not possible i think the smart service is not able to access the temporary document folder where the document is stored the other way around is, let the user upload the file and let him click on submit button after submit extract the data from the excel sheet and perform the validation in process model if some validation error occurs then redirect to form again with error message.

HI Sachin,
This is how i am doing now but just wanted to check weather i can do in the interface itself without moving to process model,
thank you