Extracting Data from Multiple Dynamic Excel Sheets for DB

Question

My use case is: I receive a dynamic Excel file from the user each time, with changing column names, different sheet numbers, and a large amount of data. I need to insert this data into the database and display it in the interface. I tried Excel-to-DB, but it doesn&rsquo;t work dynamically. I also tried using AI to extract data from Excel, but I&rsquo;m not able to extract all sheets dynamically. What should I try?

Harsha Sharma · Answer

This is not a standard usecase. The excel file should have a generic static structure so that extraction can work or AI can be trained to fetch data from. Suggest you to discuss with business to standardise the format of document for better accuracy and efficiency.