Parse excel file for RAG system

AI Discussions
,
1

Hello,
I am working on a RAG system. The system will uses excel files to do questionnaire. I want to work with excel files.
A .xlsx file contains:

  1. multiple sheets
  2. each sheet contains multiple tables
  3. tables can be nested (multi-cell column names)

I have tried working with pandas, openpyxl, but couldn’t fetch tables properly.

What can I do to parse such files?