Unable to open excel which is created in damadmin

Avatar

Avatar

srividhyabalara

Avatar

srividhyabalara

srividhyabalara

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

mjb54261515

Avatar

mjb54261515

mjb54261515

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

kautuk_sahni

Community Manager

Total Posts

6.0K

Likes

1.1K

Correct Reply

1.1K

Avatar

kautuk_sahni

Community Manager

Total Posts

6.0K

Likes

1.1K

Correct Reply

1.1K
kautuk_sahni
Community Manager

22-11-2017

Moving this question to AEM Assets topic!!