AEM Convert Excel to JSON Simple Servlet Example

[#1]

AEM Convert Excel to JSON Simple Servlet Example

  by Brian Ka Sing Li @ SourcedCode.com

Overview

In this article, I present a straightforward yet powerful solution that demonstrates how to seamlessly convert Excel data into JSON format using Adobe Experience Manager (AEM). By implementing a custom servlet, I will illustrate the process of converting an Excel sheet named ‘example.xlsx’ into structured JSON data; it can be downloaded below for you following this tutorial. This tutorial is validated on both AEM 6.5 with the latest Service Pack and AEM as a Cloud Service (AEMaaCS), ensuring its compatibility with diverse AEM environments.

Read More - > AEM Convert Excel to JSON Simple Servlet Example - Sourced Code

[#2]

Hi @BrianKasingli ,

could we try below way's?

https://github.com/vsr061/aem-excel-to-json/blob/master/core/src/main/java/com/excel/json/core/servl...

Thanks!

[#3]

Great blog!

[#4]

Hi @BrianKasingli 

Thanks for the article. How can I publish the JSON file so that is available for other components using this uploaded data?