I hope you're doing great.
I'm facing a situation where I need to dynamically extract data from Excel (.xlsx) files that contain:
Multiple tables per sheet
Different table formats
Inconsistent structures
Before I start building a custom solution, I wanted to know what others are using for this type of problem.
I came across Sheetwise, and it looks promising, but I'm not sure whether it's the fastest or most accurate option for handling highly variable Excel layouts.
My questions:
What tools or libraries do you use to automatically detect and extract multiple tables from .xlsx files?
Have you tested Sheetwise ?
Are there more robust or efficient alternatives for dynamic table extraction?
Any recommendations or insights would be greatly appreciated!
Thanks in advance.