Dear MSB,
May be I should look into your idea of providing link in a cell. For
now, it seems like the only solution possible for me.
I had thought of converting html to image and placing that image in a cell,
but that removes the option of editing in cell, which is also a requirement.
Anyways, I will look at the hyperlink option and see how it goes from there.
Thanks for all your help. I appreciate it.
Regards,
Satish HS
On Thu, Mar 12, 2009 at 1:44 PM, MSB <[email protected]> wrote:
>
> 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]
>
>
