Skip to main content
S
sandeepkumarn6107
September 13, 2023
Question

readexcelsheet() function is giving expression evaluation error

  • September 13, 2023
  • 7 replies
  • 0 views

Hi All,

While uploading incorrect / corrupted Excel sheet, readexcelsheet() function itself failing. 
How to catch the expression evaluation error when readexcelsheet() function fail to read incorrect / corrupted Excel sheet?

For your reference we have attached the screenshot:

Regards,
Sandeep

    7 replies

    peter.lewis
    peter.lewis
    Employee
    September 13, 2023

    When you say "incorrect / corrupted Excel sheet", what do you mean? Is this the wrong file type? Or some other error? What information does this display in the tomcat-stdout log? What troubleshooting steps have you tried?

    S
    sandeepkumarn6107Author
    September 14, 2023

    Hi Peter Lewis,

    This is part of Vulnerability Assessment (VA) testing. VA testing team is uploading this file from third party tool like Postman directly to our Appian application. 

    File Type is XLSX only.
    Content is changed inside of file.

    When we download the file from Appian folder and tries to open it will pop up message as shown in below screenshot:

    For this kind of files, while readexcelsheet() function is trying to read giving expression evaluation error. Is there any way to catch this expression evaluation error when readexcelsheet() function fails to read corrupted files?

    mikes0011
    mikes0011
    Brainy
    September 14, 2023

    So wait - it's obviously an invalid / dummy excel document - and you're wanting it to do something other than throwing an error message when you try using an excel-specific reading function on it?  How's that now?

    BTW in admin console you have the option to disable the upload of file types that don't match their detected underlying document type (i.e. you can't just rename a potentially harmful file to ".xslx" and get it to upload) - i'd suggest you look into that option.

    K
    kirang100133
    September 13, 2023

    Hi,

    try to use readexcelsheetpaging() function.

    S
    sandeepkumarn6107Author
    September 14, 2023

    Hi Kirang,

    Will this function readexcelsheetpaging() will be able to handle the pink error (Expression evaluation error) when trying to reading the corrupted files?

    Regards,
    Sandeep

    Terms & ConditionsAccessibility statement