You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Omar <o....@bluage.com> on 2011/10/06 13:42:41 UTC

how to get image position? in XSSFSheet

Hi, 

how can i get image position(column number, row number, ...) in XSSF Sheet ?

thanks in advance.

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/how-to-get-image-position-in-XSSFSheet-tp4876010p4876010.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: how to get image position? in XSSFSheet

Posted by Yegor Kozlov <ye...@dinom.ru>.
Unfortunately you can't. XSSF allows you only to create add images but
can't read existing ones.

One way to get this information is to grab drawing xml and parse it
yourself. You want to look at the twoCellAnchor elements in
drawing.xml:

<twoCellAnchor editAs="twoCell">
  <from>
    <col>1</col>
    <colOff>0</colOff>
    <row>1</row>
    <rowOff>0</rowOff>
  </from>
  <to>
    <col>10</col>
    <colOff>0</colOff>
    <row>30</row>
    <rowOff>0</rowOff>
  </to>

Yegor

On Thu, Oct 6, 2011 at 3:42 PM, Omar <o....@bluage.com> wrote:
> Hi,
>
> how can i get image position(column number, row number, ...) in XSSF Sheet ?
>
> thanks in advance.
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/how-to-get-image-position-in-XSSFSheet-tp4876010p4876010.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org