Unable to open excel which is created in damadmin

[srividhyabalara]

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?

[kautuk_sahni]

Moving this question to AEM Assets topic!!

[mjb54261515 · Accepted solution]

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.

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