Unable to read excel file which has text box

Certified Senior Developer

Hi Everyone,

Requirement: We need to Read the excel file which have some row data along with some text boxes. 

We are unable to read the excel file which has some row data along with some text boxes as shown below, we have tried almost all the functions, but we did not get any solutions. 

Used Plugin/Functions:

  • readexcelsheetpaging
  • validatedocumentheaders
  • excelreadcellsbyname
  • excelreadcellsbynumber

Any suggestions would be appreciated, Thanks in advance. 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    Problem: Appian's built-in Excel tools don't handle text boxes directly.

    Solutions:

    • Option 1: Preprocess Excel (if possible): If you can modify the Excel file, remove or convert the text boxes into regular cells before importing into Appian.
    • Option 2: Use RPA: Use Robotic Process Automation tools (like UiPath or Automation Anywhere ) to open the Excel file, extract text box content, and pass the data to Appian.
Reply
  • 0
    Certified Senior Developer

    Problem: Appian's built-in Excel tools don't handle text boxes directly.

    Solutions:

    • Option 1: Preprocess Excel (if possible): If you can modify the Excel file, remove or convert the text boxes into regular cells before importing into Appian.
    • Option 2: Use RPA: Use Robotic Process Automation tools (like UiPath or Automation Anywhere ) to open the Excel file, extract text box content, and pass the data to Appian.
Children
No Data