I want to import some entity to excel file. But 1 entity have attribute that it's type is binary? How can I export ?
Sorry. I cant help you with importing from excel. I never had that use case and i know no ready forge component which does that. Maybe you have the pssibility to convert the image in your excel to a base64 string ? Then you could import it and convert the base64 string back to a BinaryData?
You can't export binary datatype to excel. So I think for image case you just need to drop this column and export remaining columns. Although I think you can export the name of the image in one column but not image file.
regards
Hi,
the OfficeUtils forge component has the ability to export images to cells (although it is very limited in terms of cell styling asf).
There is also a demo application on the forge which shows how to do that.
Best
Stefan
Thanks. So can you show me how to import image from excel to outsystems?
Yes that solution is good. And I have fixed my problem. Thank you Stefan Weber