Export image in excel

[Yedukrishnan]

Hi all,

We store images uploaded by the user in a stream. I want to export the stream with images to excel and show the same in excel. 

Please let me know if any method is there to do the same. Thanks in Advance.

Yedukrishnan

[VladimirN · Accepted solution]

Article - "In ThingWorx, Is it possible to export/import Excel file with extension .xlsx": https://www.ptc.com/en/support/article/CS356165

[Yedukrishnan]

Hi @VladimirN ,

Thank you for your response. 

In this case, I need to download the image stored in the stream to CSV file. Please let me know if it is possible in Thingworx.

With regards

Yedukrishnan

[Rocko]

Most probably you will have to write your own extension using Apache POI to create an XLSX with images.

With that being said, I'm not sure you would want to store images in a stream. That is what the File Repository is for. At least I would do some scaling tests to check robustness and scalability of that approach.