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 org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTDrawing 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, somehow. 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. Yours Mark B -- 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
