Expand my Community achievements bar.

SOLVED

Unable to open excel which is created in damadmin

Avatar

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

Avatar

Correct answer by
Level 6

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

2 Replies

Avatar

Administrator

Moving this question to AEM Assets topic!!



Kautuk Sahni

Avatar

Correct answer by
Level 6

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