Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2011, 01:11 AM
saravananiyyanar saravananiyyanar is offline Adding Image into a excel cell and adding a hyperlink to the image Windows Vista Adding Image into a excel cell and adding a hyperlink to the image Office 2007
Novice
Adding Image into a excel cell and adding a hyperlink to the image
 
Join Date: Dec 2010
Posts: 10
saravananiyyanar is on a distinguished road
Default Adding Image into a excel cell and adding a hyperlink to the image

I have a requirement to create an excel and add an image into a cell and add hyperlink (url ) to the image. I am trying with Apache POI HSSF to achieve the functionality.
When I add an image into the cell with anchor option, the image is floating and didn’t reside within the cell. The suggestion was to have an idea of the image dimension and provide the row and cell width accordingly. But could not add a hyperlink to the image though.
Please provide your inputs on whether this is feasible.
Thanks


Saravanan
Reply With Quote
  #2  
Old 05-04-2011, 05:03 AM
OTPM OTPM is offline Adding Image into a excel cell and adding a hyperlink to the image Windows 7 32bit Adding Image into a excel cell and adding a hyperlink to the image Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Saravanan
I dont understand why you would want to put an image into a cell in excel then attach a hyperlink to the same image.
Please provide some more detail so we can try and help you.
OTPM
Reply With Quote
  #3  
Old 05-04-2011, 05:31 AM
saravananiyyanar saravananiyyanar is offline Adding Image into a excel cell and adding a hyperlink to the image Windows Vista Adding Image into a excel cell and adding a hyperlink to the image Office 2007
Novice
Adding Image into a excel cell and adding a hyperlink to the image
 
Join Date: Dec 2010
Posts: 10
saravananiyyanar is on a distinguished road
Default

The image to be placed in the cell will be a thumbnail image (small one). Hyperlink to the image will be an url that take you to the full size image.

Please let me know if this is possible with Apache POI HSSF.

Thanks
Saravanan
Reply With Quote
  #4  
Old 05-04-2011, 08:31 AM
OTPM OTPM is offline Adding Image into a excel cell and adding a hyperlink to the image Windows 7 32bit Adding Image into a excel cell and adding a hyperlink to the image Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by saravananiyyanar View Post
The image to be placed in the cell will be a thumbnail image (small one). Hyperlink to the image will be an url that take you to the full size image.

Please let me know if this is possible with Apache POI HSSF.

Thanks
Saravanan

Hi
Unfortunately I know nothing about Apache POI HSSF, however I do know that in Excel you can paste an image in a cell and then attached a hyperlink (url) to another location.
Hope this helps.
OTPM
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Background image vs. insert image lilaria PowerPoint 0 04-18-2011 08:45 AM
Adding Image into a excel cell and adding a hyperlink to the image adding numbers in same cell jetdude68 Word Tables 1 07-20-2010 12:30 AM
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file buggingme Office 1 05-30-2010 12:18 AM
Adding image to circle pleasehelp PowerPoint 1 05-29-2010 10:19 AM
Adding Image into a excel cell and adding a hyperlink to the image Adding PDF sussertown Office 2 06-13-2009 01:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft