AEM component: how to Fetch/Read large excel file data dynamically

Question

we have an experience/component where we read data from excel document (this is uploaded to aem) and this excel document is huge above 4mb. this excel document can have different headers like one document can have firstname, last name, etc.. and another document can have state, cities, zipcode, content field. This content field is like html text, link, phone number, anything and author like to add labels for these headers and displaying below scenarios dynamically

And upon selection of state, we display cities

And upon selection of cities , we display zipcodes

and upone selection of zipcode, we display content field

Please let me know how to achieve this scenario. if excel document is not possible let me know is there any ways we can actually process this data into different formats like nodes, json or creating some apis

RajaShankar · Accepted Answer

Hi @rajreddy07 I would suggest to usea) API if available to fetch this data in realtime and populate the component based on selection.We had implemented this kind of requirement for PIM data at run time.b) Other option is if you can export this as a JSON format under content then you can fetch this json in your component at runtime and populate the fields based on user interactionsc) Else create a scheduler to create the values as nodes and properties in your jcr nodes which your component can parse.(If data volume is large and frequency of data change is less then you can with this option rather than option a) Regards,Rajashankar

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded