create aem pages, templates ,tags by reading from Excel

[AEM1234567890]

i need code for creating pages templates tags by reading from excel 

please help me with code and clear explanation 

excell should be like this

[arunpatidar]

Please check https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp-tools/data-importer/index.h... 

[AEM1234567890]

Thanks for the reply .

but i want the code 

creating pages with diff differnt templats , and tags by reading the excel 

[arunpatidar · Accepted solution]

I don't think, so anybody is going to share there internal project code or if they have the same requirements.

You can get the code from github for the above features that I have shared for reference.

https://github.com/Adobe-Consulting-Services/acs-aem-commons/blob/master/bundle/src/main/java/com/ad... 

[ShaileshBassi]

Hi @AEM1234567890 

You can use the below create the logic using the APIs available for reading the excel.

one of the way is to use read the excel file using these, where you get the value of the each cell 

org.apache.poi.ss.usermodel.Cell;
org.apache.poi.ss.usermodel.Row;
org.apache.poi.ss.usermodel.Sheet;
org.apache.poi.ss.usermodel.Workbook;
org.apache.poi.ss.usermodel.WorkbookFactory;

once you get each cell value you can leverage it and pass to the PageManager method 

pageManager.create(<complete-path>,<page-name>,<template-name> StringUtils.EMPTY);

Hope this helps!

Thanks