MicrosoftThis works great for me if I am just browsing pdf, .docx, and txt files, i.e. connecting via Sharepoint Indexer and targeting the index and seeing it in the Chat Playground. But my challenge has always been excel files. I have a Sharepoint Indexer pointing to a Document Library using the "useQuery". Even though there are 2 folders and one file, only contents from the first folder was indexed. The excel files has two worksheets but only the first worksheet was indexed. What was indexed in the content field was a bunch of gibberish in the Field Explorer of that index. In the Playground, data is not queryable.
Has anyone successfully index excel files? I can control what is indexed via Microsoft Graph API but I still have the same problem with gibberish in the index and data not being queryable for Excel worksbooks. What approach are others using? Do I need to look at embeddings? Any insight would be great!
Thank you in advance.
