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

[AnmolBhardwaj1808]

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-sta... )
• 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.

[Prashant54]

but if we have to make it with event handle then?

[AnmolBhardwaj1808 · Accepted solution]

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 with

Event.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.