Yes @Madhuri Patil , the format remains same. however, when attempting to view the uploaded file, it displays as an error file.

Hi Mani,

My sole intention is to export and import binary data (PDF/Word) within Excel. I'm just wondering if there's any method within OutSystems to accomplish this or if we need to resort to using a .NET extension. Have you encountered a similar situation before?

Thanks,
Abinaya

Hello Siya ,

Yes am trying to import and export Binary data  (PDF/Word)  within Excel.

Please find the Samplke App oap and OML file .

Thanks,

Abinaya

I understand you want to show a list of employees in a table and allow users to upload binary data (like photos and PDFs) for each row, then export this data to Excel. Directly copying binary data into a cell won't work; instead, you need to embed the data as OLE objects. Underlying library which Advanced Excel uses is EPPLus and that does not support OLE Objects. 

Suggested Approach

1. Store Binary Data:

   • Create a separate entity in your database to store the binary files associated with each employee.

2. Export to Excel:

   • Use a library like Spire.XLS for .NET to build the Excel file and embed the binary data as OLE objects. ( you need to build extension using this )
   • Reference: Spire.XLS Tutorial on Embedding OLE Objects

3. Alternative Approach:

   • Upload the files (binary data) to a cloud service and embed the URLs in the Excel file.
   • If cloud storage is not an option, create an anonymous page that accepts an ID to uniquely identify and serve each file, and embed these URLs in your Excel file.

Hope this clarifies.

Thank you for providing the detailed explanation,The suggested approach makes sense. 

 I'll proceed with implementing one of these approaches and keep you updated on the progress.