Hi This is sort of related to this thread.I just want to create a hyperlink on a image in a cell. Excel allows it but there is no example or api method I can find that does that
Here is the code I have and it does not create hyperlinks on images. Mark talked about icons with links. how do you do that Mark with XSSF? I could use the same idea for images as hyperlinks. Thanks for any pointers. Regards A -----Original Message----- From: MSB [mailto:[email protected]] Sent: Thursday, March 12, 2009 10:44 AM To: [email protected] Subject: Re: Writing html code to xls cell The problem - at least to my mind - that you face, is that you wish to place a rendered copy of the html markup into a cell; and it is the 'rendering' part of the problem that is the real stumbling block. The only way that I can think of to accomplish this is to use something like IE or Firefox to open the html and generate a rendered page, then grab an image and save that away as a bmp or jpg - I cannot remember which one can be placed onto a spreadsheet offhand sorry - then you could position the image onto an Excel spreadsheet. Even then, I do not think that you can guarantee that each image will occupy a single cell. Furthermore, I think that you will face just the same sorts of issues with .doc or Rich Text Format files, because both include the content - the text, tables, pictures, etc - and formatting information. Could you not look at modifying what you want to do? I know that it is possible to place hyperlinks into cells, what I do not know is whether you could create an icon that sort of resembles the document you want to open, place that in the cell, mark it as a hyperlink and link to the original file such that if the user clicks on the icon the file is opened using the default application for that file type; Word for .doc and .rtf (propably), IE or Firefox for html files and so on. Aside from that, I am out of ideas, sorry. Satish HS wrote: > > Dear MSB, > Thanks again. Yes, My requirement is to write a complete html page to one > single cell. However, if that is not possible, I would like to know if > there > is any way to write a complete .doc file or any RTF file to a single cell? > > Or any other swing component that I can use for rich text editing whose > content can be exported to a single cell retaining all the format? > > Thanks for your help. I hope you don't mind me asking further. > > Thanks, > Satish HS > > > On Thu, Mar 12, 2009 at 3:23 AM, MSB <[email protected]> wrote: > >> >> Have you changed the requirement or are you saying that you want to open >> an >> html file, parse the markup, render a complete page so that it resembles >> the >> sort of display you would see in a browser,and then write that page into >> a >> single cell of an Excel spreadhseet? If so, then the answer is no, sorry. >> I >> do not have the ability, skills or time to create what amounts to a >> browser. >> >> >> Satish HS wrote: >> > >> > Thanks for the response. I truly appreciate it. Regarding your question >> > about the font and size, it will be specified in the html code.My >> actual >> > need is to populate each cell with separate html-files. So, each cell >> > corresponds to a html-file. >> > I already have the java code which stores the html code in text >> file(s), >> > how >> > can I populate each cell with separate file. >> > Can I do this with your solution of using Desktop class? Can you send >> me >> a >> > small code snippet of it, if its not too much to ask. >> > >> > Thanks, >> > Satish HS >> > >> > >> > On Wed, Mar 11, 2009 at 2:19 PM, MSB <[email protected]> wrote: >> > >> >> >> >> Right, now I understand. You want HSSF to parse html markup for you. >> >> >> >> The short answer to your question then is no, it cannot do this. You >> will >> >> have to create a tool to parse the html and extract the information >> from >> >> the >> >> markup to create the cells. As an example of what I mean, what font >> and >> >> what >> >> size should HSSF use to render the example you gave? >> >> >> >> Just a simple question, why do you want to use HSSF to populate an >> Excel >> >> spreadsheet in this manner? Did you know that you can use Excel to >> open >> >> an >> >> html file and that it - Excel that is - can parse the markup and >> render >> >> the >> >> page for you? A short way around your problem would be to use Java to >> >> create >> >> a text file containing the html code and then ask it to start Excel >> for >> >> you >> >> using the Desktop class. >> >> >> >> >> >> Satish HS wrote: >> >> > >> >> > Alright, here is my need, My input is a html String as below: >> >> > String str = "<html>Some word</html>"; >> >> > >> >> > How do I pass this on using the API to Excel Cell, I want the excel >> >> cell >> >> > to >> >> > display "Some word" in italic. >> >> > The actual need is not just to display the italic but to support all >> >> types >> >> > of html (rtf, background color, font, including images etc..) >> >> > I hope it is clear now, please let me know if you any doubts. >> >> > >> >> > Regards, >> >> > Satish HS >> >> > >> >> > >> >> > On Wed, Mar 11, 2009 at 3:56 AM, MSB <[email protected]> >> wrote: >> >> > >> >> >> cell >> >> > >> >> > >> >> >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/Writing-html-code-to-xls-cell-tp22441551p22461389.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] >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Writing-html-code-to-xls-cell-tp22441551p22471025.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] >> >> > > -- View this message in context: http://www.nabble.com/Writing-html-code-to-xls-cell-tp22441551p22481814.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]
