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

SOLVED

Unable to open excel which is created in damadmin

srividhyabalara
Level 1
Level 1

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?

1 Accepted Solution
mjb54261515
Correct answer by
Level 5
Level 5

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

View solution in original post

0 Replies
kautuk_sahni
Community Manager
Community Manager

Moving this question to AEM Assets topic!!

mjb54261515
Correct answer by
Level 5
Level 5

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

View solution in original post