Hello, in my previous post https://www.outsystems.com/forums/discussion/98310/advanced-excel-advanced-excel-write-cell-with-a-binary-file/#Post426012 I asked a question about uploading objects in an excel file(like pdfs or powerpoints, any type of binary files) like this
and I tried to write in the cells the files that I upload as objects using cell_writeRange function from advanced excel like this
for the images it works because of the writeImage action but the closest I got to a solution was with the approach I used that is: to create a structure list with the Binary File content of what I upload and use it with the action cell_writerange like in the previous screenshot, but the result is this:
I do not know what those numbers mean but I know I uploaded 2 files so that numbers must refer to the files in a way or another, I can change the implementation so that when I download the edited file to download the uploaded files aswell but I wanted to ask if someone has another way of doing this I would be very grateful, thank you! I cannot provide the oml unfortunately.
Hi Teodor
Those numbers are the upper and lower limits for the integer type.
As far as I am aware the component doesn't know how to handle binary files with the Cell_WriteRange action that you are using and that is why you are having the issues.
This probably applies to your other post as well.
Hope this provides some clarity.
Hanno
Iirc, objects (like images) aren't bound to a cell, so that kinda makes sense.
I know that the images are not written in a cell, but on the cell and over other if the size is not given. But from what I have learned till now I haven't found a solution only to store the binary files in a database with identifier for the specific file and then download as a zip.
I did some simple checks, and OLE-embedded objects aren't put in a cell at all, they have their own plane of existence, like text boxes and images. So it makes total sense to me that you can't add an object with a WriteRange or similar.
I'm also not sure that EPPlus, the library used, supports embedded objects. There seems to be no mention of it in the feature set.