Read dynamic excel headers

Hi,

We are working on reactive application. We want to create a solution where customer will upload his/her own excel template. We have to store excel template and next time when user upload data then we need to store data in database.

In this scenario "ExcelToRecordList" widget is not helpful because our data structure is not fix. We have to deal with multiple client templates. We are thinking to keep template headers in entity with client ID and keep excel header mapping with entity columns.

How we should deal with this situation?

Best Regards,

Nitin

mvp_badge
MVP
Solution

Hi Nitin,


That's true that the ExcelToRecordList widget serves for the most basic scenarios but falls short for some more advanced scenarios like the one you mention. For those scenarios, you will need something like Advanced Excel forge component.


It has a comprehensive documentation and demo that can guide you on how to set it up to achieve your use case.


Kind Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.