how to read data from excel sheet in xlsx by uploading in dam and create tags automatically by servlet?

Question

No text available

Anmol_Bhardwaj · Accepted Answer

It's pretty much the same thing,if you have to use event handler instead, Instead of step 1 & 2, what you need to do is,Create event handler withEvent.NODE_ADDED for the required DAM path.Then , you can use the event.getPath() method to get the path of the affected item. E.g. the added/removed node or the property that was added/removed/changed.After that, it's the same steps.

Anmol_Bhardwaj · Answer

Here's what I would do:Assuming, the XLS files would be uploaded in a particular folder in the DAM. Create a workflow launcher config to run a custom workflow whenever an asset in uploaded under a particular path. ( https://experienceleague.adobe.com/docs/experience-manager-64/administering/operations/workflows-starting.html?lang=en )Create a custom workflow (https://aem.redquark.org/2018/10/day-15-custom-workflows-in-aem.html)In this workflow, the payload should include the asset and then perform a process step in the backend where we would read the data from the excel (https://mkyong.com/java/jexcel-api-reading-and-writing-excel-file-in-java/ )After that, you can easily create tags based on your requirements through JCR API.

Sign up

Login with SSO

Login to the community

Login with SSO