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
BedrockMission!

Learn More

View all

Sign in to view all badges

Unable to open excel which is created in damadmin

Avatar

Avatar
Validate 1
Level 1
srividhyabalara
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
srividhyabalara
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
srividhyabalara
Level 1

21-11-2017

Task is to create excel with AEM User's data. I can successfully able to create excel with AEM user's data and stored under dam. i can able to download also from DAM. But unable to open excel in my local, getting exception. Below is the code which i used to create excel.

assetManager.createAsset("/content/dam/uk/test-report.xlsx", is, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", true);

Could you please help me resolve this issue or provide me any document which has basics for creating excel?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 4
mjb54261515
Level 4

Likes

33 likes

Total Posts

132 posts

Correct Reply

32 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 4
mjb54261515
Level 4

Likes

33 likes

Total Posts

132 posts

Correct Reply

32 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
mjb54261515
Level 4

22-11-2017

Yes Faced this issue multiple times. .pdf files can are opened in AEM but .xlsx file is not able to open in AEM, it only downloads the file. The downloaded file is looks good.

This is actual AEM OOB behavior as mentioned in documentation. It does not allow asset extraction or thumbnail generation.1355768_pastedImage_2.png

Assets Supported Formats - docs.adobe.com

I have tried adding "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" mime type in "Apache Sling MIME Type Service" in configuration but dint work.

Some one in previous post already tried this and it dint work too.

Re: Create Excel Programmatically | Assetmanager API

Thanks

Manoj

Answers (1)

Answers (1)

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,164 likes

Total Posts

6,273 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,164 likes

Total Posts

6,273 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

22-11-2017

Moving this question to AEM Assets topic!!