readexcelsheet function

Hi Bharghavi,

Could you please elaborate your scenario? Why you want to read the file in a!save(). does that file is already avilable in the document folder or is it just uploaded by user and not present in the appian document folder?

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

That file will be uploaded by the user and i need to read the data and need to don some validations to that data.

Hi Bharghavi,

I think it is only read the documents which is already uploaded to Appian document. If you see the code of that particular plugin it will take the document from the appian document folder. If you just upload the document and it is not yet persist in the appian document folder then you can't read it.

Hi Bhargavi, The file need to be saved in Appian Doc Folder for using that in the readExcelSheet function. So make the button submit and mimic the same form in a different user input task with activity chaining in between them.

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