Guidance on implementation

[Sagar Nikesh]

I've got a project with problem statement :

identifying an appropriate Python library for Excel parsing (document different options & trade-off as applicable); implement extraction and basic chunking (layout preferable) modules for Excel and integrate the code with existing data ingestion pipeline. The code should work for basic tables across multiple sheets. If time permits, you can explore charts, graphs, pivot table extraction from Excel (may be stretch goal).

Can it be done using openpyxl ? Please guide on implementation

[udif]

Yes, it can be done, as long as you need to process modern Excel files ("xlsx") and not the ancient binary files ("xls").