How do I insert a picture as embedded in a cell ?

[zhjiarong]

I want to insert a picture as embedded in a cell. How do I do that with OpenXLSX? thank you

[aral-matrix]

May I ask why you closed this as completed? It's a legitimate feature request :) Currently not possible, but I will keep this in mind and let you know when it gets implemented, as part of the preparatory work (worksheet relationships) is now implemented.

[wen-gp]

Hello, may I ask if OpenXLSX now supports inserting images?

[aral-matrix]

Hi @wen-gp - I am sorry, but I haven't yet gotten around to it. The groundwork has been layed when I implemented comments support, but I was busy with other projects. I hope to implement picture support in the coming months. It's definitely on my to-do-list.

[wen-gp]

@aral-matrix Hi,thank you very much for taking the time to reply to me amidst your busy schedule. Wishing your project all the best.：）

[macstevens]

@aral-matrix , answering #378 (comment)

I needed to embed images, so I implemented it myself: #378 -- https://github.com/macstevens/OpenXLSX/tree/development-embed-image Based on this, here are some recommended features for the official OpenXLSX implementation:

1. Memory and file size efficiency. In particular, I mean that if you add multiple instances of the same image in one document, it keeps only one copy of the image data in memory and stores only one copy to disk when saved. Excel does not even do this -- it just duplicates the data.

2. Read a file, iterate images.

3. Add and remove images. You can read a file, add or remove images, and save the resulting document. If you remove all the images in a worksheet, it cleans up the XML just as if no images had been added. If you have multiple copies of the same image in a document, as you remove instances of that image, it keeps track (via shared_ptr, for example) how many are in use and cleans up upon document save, as appropriate.

4. Demo11.cpp and testXLImage.cpp provide many examples and a fairly thorough unit test.

5. I worry about reliance on a hash function for image equivalence (which is exactly what I did). It will probably never fail, until it does fail at the worst moment.

Again, I appreciate your work for providing OpenXLSX. It has worked well for me.

Mac Stevens