export JCR properties to excel sheet | Adobe Higher Education
Skip to main content
S
sivas61374651
Level 3
August 24, 2018
Respondido

export JCR properties to excel sheet

  • August 24, 2018
  • 3 respostas
  • 3237 Visualizações

Hi All,

I want to export the jcr:content of the page including all the component details like property name and value to the excel sheet. I need to do this in AEM 6.1. Can anyone already did like this? Appreciate your help.

Feike Visser​smacdonald2008​Arun Patidar​

Thanks,

Vijay

Este tópico foi fechado para respostas.
Melhor resposta por Ratna_Kumar

Hi Siva,

Yes, we can do it. We have an HELPX article that talks about your use case.

Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager

Thanks,

Ratna Kumar.

3 Respostas

Ratna_Kumar
Ratna_KumarResposta
Level 10
August 24, 2018

Hi Siva,

Yes, we can do it. We have an HELPX article that talks about your use case.

Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager

Thanks,

Ratna Kumar.

V
varshads1992
July 24, 2020
is this supported in AEM version 6.4?
S
sivas61374651Autor
Level 3
August 24, 2018

Hi Ratnakumar,

Thanks for your reply. I have read the link and that link is for reading the data from DB using datasourcepool and export into Excel. But my requirement is, I'm having some contents in page and just want to export the content in to Excel/txt file. I believe, to achieve this I no need to go with an any costly operation like the link which you provided.

Thanks,

Vijay

smacdonald2008
smacdonald2008
Level 10
August 24, 2018

To write out data to Excel -- yOu need to write a custom service that uses Excel API. It does not matter where the data comes from - a relational database, the JCR, etc, You still need to write an AEM Service that uses the Excel API as specified in that link that Ranta provided. AEM does not offer an OOTB Excel endpoint.

Termos e condiçõesAccessibility statement

Loading footer...