I’m testing an Appian AI Agent that needs to read data from an XLSX document. I have two copies of the exact same XLSX file stored in two different folders in Appian.
Both documents are valid Appian documents of type .xlsx, AI Agent uses Semantic Search to read the data, and the file contents are identical. The only difference is the folder they’re stored in.
.xlsx
Has anyone seen this behavior before or can suggest what to check? Any guidance on why the same file would work in one folder but not another would be appreciated. I created new folders, checked the folder security, but I can't find the issue.
Discussion posts and replies are publicly visible
It turns out there is an Appian indexing that takes place in the backend after the Excel file is uploaded, so recently uploaded file is not readable by the AI... If anyone knows any solution please share
Hi adamb9906 , Could you please guide me on how you are achieving this? Specifically, how are you extracting data from the Excel file using the AI agent? I tried implementing it, but I encountered the following error: “An error occurred while executing the tool [SemanticSearch]: The user [username] does not have sufficient privileges to perform the requested action.” Any guidance on how to resolve this would be really helpful.
Hi adamb9906 , the XLSX file format isn't currently supported in agent studio. A workaround is to convert the file to PDF before providing it to the agent. This should work for simple XLSX files, more advanced excel handling is planned for the future.