Creating a custom Excel Service for Adobe Experience Manager

While helping answer forums for Adobe Experience Manager, an AEM user asked how to create a CQ service that is able to import an Excel spreadsheet, read the data from the excel spreadsheet, and update the AEM Java Content Repository (JCR) with data read from the spreadsheet. While this is not an out-of-the-box feature, it does not mean that Adobe CQ cannot perform this use case. One of the most powerful features of AEM is the ability to develop custom services.

You can create a custom AEM service that accepts an Excel spreadsheet, reads the data within the spreadsheet, and writes the data to the AEM JCR. For example, consider the following spreadsheet that contains customer data. Once you upload this file to AEM, the customs service reads the customer data and persists the data in the AEM JCR.

An Excel Spreadsheet that contains customer data

This development article walks you through how to create a custom AEM service that accepts a spreadsheet, reads the data and updates the AEM JCR with the data. 

To read this development article, click:
http://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html