Dear Mark,
Thank you for the answer. Yes, it is pure xls file I'm working with. The glasspane example was good, thanks. Anywway, the coordinate of this floating embedded text file is attached somehow to the cell. If I rescale the cells, scroll the screen, the attached object will remain still at the same local position of the cell graphical element. I haven't found any way to get this coordinate yet... :( Best regards, Imre -----Original Message----- From: Mark Beardsley [mailto:[email protected]] Sent: Friday, February 18, 2011 4:59 PM To: [email protected] Subject: RE: how-to extract textual embedded content No, you were not careless at all. I think - and this is think - that embedded documents are a little like pictures. By this, I mean that they are not actually inserted into a cell but they 'float' above the worksheet and are anchored to it. To try and explain what I mean, an example is useful. I do not know how familiar you are with Java's Swing components, those used to create graphical user interfaces. Each component - a textbox for example - consists of a series of objects and a couple of these are called panes. One pane is invisible, lies over the textbox object, glories in the name the glass pane and you can use it to check whether the user has clicked the mouse cursor whilst they are within the box for example. Now, imagine that there is a glass pane positioned above the worksheet and that you can view the rows and columns through it. Images, and I think embedded documents, are actually attached to the equivalent of a glass pane and their location expressed in terms of the cell(s) their corners line within. Of course, Excel does not have the glass pane but it serves to explain what I mean by saying that embedded objects 'float' above the worksheet. It ought to be possible to get at the imformation but I am not certain where it is stored in the file. Also, it will be stored differently for each file type; the older binary .xls fileas and the newer OOXML based ones. Did you mention which file format your application is targetting by the way? Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/how-to-extract-textual-embedded- content-tp3390878p3391311.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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
