Parse excel file for RAG system

,

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?