You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by amwebexpert <am...@gmail.com> on 2013/03/14 05:29:47 UTC
RE: Excel image sizes
Hi Mark,
I'm interested to know if you found the solution for that particular image
size problem. I have to extract images from Excel files and also we must
know the exact image position and size as it appears inside Excel...
Thanks,
André
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712327.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: Excel image sizes
Posted by amwebexpert <am...@gmail.com>.
Mark thank you so much for this previous information!
_____
André Masson
J2E & Android Specialist
On 2013-03-15 4:08 AM, "Mark Beardsley [via Apache POI]" <
ml-node+s1045710n5712351h49@n5.nabble.com> wrote:
> Yes, that is the project I was referring to and yes again, the revisions
> should be a part of version 3.8 as far as I am aware. From what I do
> remember, the work undertaken was at quite a fundamental level and did
> include a revision of the Escher layer objects. Since it was completed, I
> have not needed to work with images again and so have not looked closely to
> see what the changes were but it may be the case - that is may -m that it
> is now possible to simply and directly link from escher to picture. If my
> very dodgy, aging memory is accurate, that was the problem we faced before;
> getting the preferred size from the picture gave us duff info but getting
> the escher records allowed us to establish the image's actual size.
> However, at that point in time it was not possible - at least it was not a
> trivial task - to work out which chunk of the escher records related to
> which picture. Maybe that has changed now. I do not know if this is the
> case but feel it might be worth looking into.
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712351.html
> To unsubscribe from Excel image sizes, click here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5582506&code=YW13ZWJleHBlcnRAZ21haWwuY29tfDU1ODI1MDZ8LTE5Mzg0MDIwODc=>
> .
> NAML<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712356.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: Excel image sizes
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
Yes, that is the project I was referring to and yes again, the revisions
should be a part of version 3.8 as far as I am aware. From what I do
remember, the work undertaken was at quite a fundamental level and did
include a revision of the Escher layer objects. Since it was completed, I
have not needed to work with images again and so have not looked closely to
see what the changes were but it may be the case - that is may -m that it is
now possible to simply and directly link from escher to picture. If my very
dodgy, aging memory is accurate, that was the problem we faced before;
getting the preferred size from the picture gave us duff info but getting
the escher records allowed us to establish the image's actual size. However,
at that point in time it was not possible - at least it was not a trivial
task - to work out which chunk of the escher records related to which
picture. Maybe that has changed now. I do not know if this is the case but
feel it might be worth looking into.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712351.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: Excel image sizes
Posted by amwebexpert <am...@gmail.com>.
Interesting... Are you talking about this particular project [
http://www.google-melange.com/gsoc/project/google/gsoc2012/evgeniy44/6001] ?
Does this effort is not part of Apache POI 3.8 ?
On Thu, Mar 14, 2013 at 12:31 PM, Mark Beardsley [via Apache POI] <
ml-node+s1045710n5712343h1@n5.nabble.com> wrote:
> Details elude me, but I do remember that a significant amount of work was
> undertaken on the image handling side of things for a GSOC project - I
> think. It may well be that the problem has been addressed during this
> process but I do not know that for certain; when I say 'problem' here, I
> mean tying the Escher records back to a specific image in the workbook. It
> did seem as though working with the Escher layer offerd the best
> opportunity to determine the images actual size.
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712343.html
> To unsubscribe from Excel image sizes, click here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5582506&code=YW13ZWJleHBlcnRAZ21haWwuY29tfDU1ODI1MDZ8LTE5Mzg0MDIwODc=>
> .
> NAML<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
André Masson
Senior JEE and Android Software Engineer
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712344.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: Excel image sizes
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
Details elude me, but I do remember that a significant amount of work was
undertaken on the image handling side of things for a GSOC project - I
think. It may well be that the problem has been addressed during this
process but I do not know that for certain; when I say 'problem' here, I
mean tying the Escher records back to a specific image in the workbook. It
did seem as though working with the Escher layer offerd the best opportunity
to determine the images actual size.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712343.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: Excel image sizes
Posted by amwebexpert <am...@gmail.com>.
No problem Mark we all have priorities and this is the way open source
projects work. Thanks for your feedbacks!
On Thu, Mar 14, 2013 at 4:02 AM, Mark Beardsley [via Apache POI] <
ml-node+s1045710n5712330h98@n5.nabble.com> wrote:
> Sorry to say this but I never went any further with the investigation as I
> did not receive a reply. We now use Open/LibreOffice exclusively and, as a
> result, my contributions here have dwindled and I can now only really help
> answer the most obvious of questions. Which is all, I guess, a roundabout
> way of saying that no, I do not have the answer to your question, sorry.
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712330.html
> To unsubscribe from Excel image sizes, click here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5582506&code=YW13ZWJleHBlcnRAZ21haWwuY29tfDU1ODI1MDZ8LTE5Mzg0MDIwODc=>
> .
> NAML<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
André Masson
Senior JEE and Android Software Engineer
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712340.html
Sent from the POI - User mailing list archive at Nabble.com.
RE: Excel image sizes
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
Sorry to say this but I never went any further with the investigation as I
did not receive a reply. We now use Open/LibreOffice exclusively and, as a
result, my contributions here have dwindled and I can now only really help
answer the most obvious of questions. Which is all, I guess, a roundabout
way of saying that no, I do not have the answer to your question, sorry.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-image-sizes-tp5582506p5712330.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