Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Store Page Properties In Excel

Avatar

Level 3

Hi Gems...!

Greeting Of the Day...!

how to store page properties to excel sheet in aem and download excel sheet from webpage..Jörg Hohkautuksahnidgordon86smacdonald2008tim-schwalbeEncore

2 Replies

Avatar

Level 1

You are in the Encore (DVD/BD authoring) forum.

Avatar

Level 10

this is quite easy. You need to use QueryBuilder to query the pages you are interested in. That is, read the page props. Then you can save the page props to a Java Collection and write the result set to an Excel doc that you create using the API.

This is all custom and can be implemented as an AEM Service.

Avatar

Level 10

Here is an older article that shows use of the Excel API within AEM (it reads from an Excel spreadsheet)  -- Adobe Experience Manager Help | Creating a custom Excel Service for Adobe Experience Manager

Avatar

Level 3

yeah this link is referred ,i will  store properties from aem to excel file. not for  excel to aem