Thanks for that Milos. I think that the key is most likely in the Target
attribute for the relationship. That contains the URL that should allow you
to link directly to the source of the image and download any update.
As for javadocs for the openxml4j layer, well I am afraid that I do not
believe that there are any. The good news is that most of the objects you do
need to get your hands on in the openxml4j layer should be available from
client code, without the need to make any changes to the underlying API. If
you are using an IDE like NetBeans for example, it often opens up prompts
that display just what is accessible from which class and that can help you
to drill down into the structure of the openxml4j layer to get at the
objects you require. Over the next day or so, I should have the chance to
play with some code to see what I can come up with and I will download both
of your example files to my PC to play around with. It may be that we have
to unpack the document 'manually' so to speak using the various
relationships but I am hoping that this is not the case. As a first step, I
am going to do something like this;
1. Open the workbook.
2. Get a sheet.
3. On that sheet object, call the createDrawingPatriarch() method.
This will return an instance of the XSSFDrawing class from which I can get
at the openxml4j object called
which is the root element of the drawing hierarchy for pictures in that
sheet. I am hoping that this, or objects it contains, will allow me to dig
down to discover the type of information we are looking for.
Now, just out of interest, do you need to update the drawings in the
workbook file using java code or are you simply trying to discover what they
are? If the latter, then our task ought to be fairly easy, if the latter
then we are going to need to get at the stream that connects us to the
drawing data held in the workbook file and update it from the data source,
Anyway, will posts of I make any progress this evening and all the best with
your searches. Keep me updated if you would with your progress.
View this message in context: http://apache-poi.1045710.n5.nabble.com/Load-remote-image-inside-excel-sheet-tp5709821p5709859.html
Sent from the POI - User mailing list archive at Nabble.com.