[Question]: Multi xlsx (excel) Pandas Query Engine

[muratali016]

Question Validation

• I have searched both the documentation and discord for an answer.

Question

has anyone created before multi-query engine for Excel files, basically excel version xlsx files for this app: https://gpt-index.readthedocs.io/en/stable/examples/agent/multi_document_agents.html

[dosubot[bot]]

🤖

Hello @muratali016,

I'm here to assist you with your query. Based on the context provided, it appears that the LlamaIndex's MultiStepQueryEngine does not currently support querying from Excel (.xlsx) files. The DEFAULT_FILE_READER_CLS dictionary, which maps file extensions to their respective reader classes, does not include an entry for the ".xlsx" extension. This suggests that the current implementation of LlamaIndex does not have a built-in reader for Excel files.

Here is the DEFAULT_FILE_READER_CLS dictionary for reference:

DEFAULT_FILE_READER_CLS: Dict[str, Type[BaseReader]] = {
    ".hwp": HWPReader,
    ".pdf": PDFReader,
    ".docx": DocxReader,
    ".pptx": PptxReader,
    ".jpg": ImageReader,
    ".png": ImageReader,
    ".jpeg": ImageReader,
    ".mp3": VideoAudioReader,
    ".mp4": VideoAudioReader,
    ".csv": PandasCSVReader,
    ".epub": EpubReader,
    ".md": MarkdownReader,
    ".mbox": MboxReader,
    ".ipynb": IPYNBReader,
}

As for your question about whether there are any existing extensions or plugins for the LlamaIndex that could add support for Excel files, I wasn't able to find an answer within the repository. It's possible that such an extension or plugin exists elsewhere, or that I may have missed it.

I hope this information is helpful. If you have any further questions or need more clarification, feel free to ask.

Best regards.

Sources

• llama_index/query_engine/init.py
• llama_index/readers/file/base.py

---

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.

[muratali016]

🤖

Hello @muratali016,

I'm here to assist you with your query. Based on the context provided, it appears that the LlamaIndex's MultiStepQueryEngine does not currently support querying from Excel (.xlsx) files. The DEFAULT_FILE_READER_CLS dictionary, which maps file extensions to their respective reader classes, does not include an entry for the ".xlsx" extension. This suggests that the current implementation of LlamaIndex does not have a built-in reader for Excel files.

Here is the DEFAULT_FILE_READER_CLS dictionary for reference:

DEFAULT_FILE_READER_CLS: Dict[str, Type[BaseReader]] = {
    ".hwp": HWPReader,
    ".pdf": PDFReader,
    ".docx": DocxReader,
    ".pptx": PptxReader,
    ".jpg": ImageReader,
    ".png": ImageReader,
    ".jpeg": ImageReader,
    ".mp3": VideoAudioReader,
    ".mp4": VideoAudioReader,
    ".csv": PandasCSVReader,
    ".epub": EpubReader,
    ".md": MarkdownReader,
    ".mbox": MboxReader,
    ".ipynb": IPYNBReader,
}

As for your question about whether there are any existing extensions or plugins for the LlamaIndex that could add support for Excel files, I wasn't able to find an answer within the repository. It's possible that such an extension or plugin exists elsewhere, or that I may have missed it.

I hope this information is helpful. If you have any further questions or need more clarification, feel free to ask.

Best regards.

Sources

• llama_index/query_engine/init.py
• llama_index/readers/file/base.py

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.

#8535 (comment) @dosu-bot can I use csv files here https://gpt-index.readthedocs.io/en/stable/examples/agent/multi_document_agents.html in Multidocument agent documentation

[muratali016]

@dosu-bot

[muratali016]

I want to create multi xlsx pandas query engine

[dosubot[bot]]

🤖

@logan-markewich, I could use your expertise on this one.

---

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.

[tanzeel291994]

Any update , do we have the document loader for xlxs files?