Ah, that's because it does not exist....but you might like to write one and
submit it to the project. Forgive the heavy handed hint please and the time
it took to reply. You must have posted your reply as I was writing mine in
response to David's question. Seriously though, it should not be too hard to
write a method to parse the HTML and 'convert' it into a rich text string
that can then be placed into a cell. The problems will increase in direct
proportion to the complexity of the HTML in my opinion. If you can limit the
sort of markup you want to parse then it should not be too difficult to
accomplish this task.
Yours
Mark B
Guilherme Mussi wrote:
>
> Hey, thanks for your reply, but actually my question was exactly how to
> build a cell (with the XSSF api) from a simple html snippet.
>
> Something like
>
> RichTextString rts = parseHtmlToRichText("some
> text here");
>
> I searched for such function but couldn't find anyhting.
>
> Regards,
>
> --
> Guilherme Petterle Silveira Mussi
>
> Conrad Caine Media Applications GmbH
>
> Mobile: +55 53 91257012
> Office: +55 53 30275721
>
> "Any fool can know. The point is to understand." - Albert Einstein
>
>
> On Thu, May 20, 2010 at 12:52 PM, David Fisher
> <dfis...@jmlafferty.com>wrote:
>
>> Hi Mark,
>>
>> I am curious what happens if you write strict XHTML to a cell in XSSF?
>>
>> Regards,
>> Dave
>>
>> On May 20, 2010, at 8:50 AM, MSB wrote:
>>
>> >
>> > So, let me get this clear, you are NOT asking how to use POI but a more
>> > general question about Excel - how to place HTML into a cell?
>> >
>> > If this is the case then the answer is no and yes, confused? Had a
>> quick
>> > google and found someone had written a macro that you may be able to
>> build
>> > upon/develop further;
>> >
>> > http://www.dailydoseofexcel.com/archives/2005/02/23/html-in-cells-ii/
>> >
>> > This perhaps answers the more general question about HTML in cells;
>> >
>> >
>> http://stackoverflow.com/questions/1842071/can-excel-interpret-a-cell-as-html
>> >
>> > and the conclusion seems to be that what you are asking is not
>> currently
>> > possible unless you write a clever little macro to interpret the HTML.
>> >
>> > Yours
>> >
>> > Mark B
>> >
>> >
>> > Guilherme Mussi wrote:
>> >>
>> >> Hello Folks, i'm writing to this list after a couple hours of google.
>> >>
>> >> I need to know whether it is possible to write an html snippet to a
>> cell?
>> >>
>> >> just some tags setting the text as bold, italic, underlined, and also
>> >> <ul> and <li>
>> >>
>> >> can you tell me if there is any kind of implementation for this
>> anywhere
>> >> on
>> >> the net? as i don't think just poi will help me with that.
>> >>
>> >> Appreciate the help,
>> >>
>> >> --
>> >> Guilherme Petterle Silveira Mussi
>> >>
>> >> Conrad Caine Media Applications GmbH
>> >>
>> >> Mobile: +55 53 91257012
>> >> Office: +55 53 30275721
>> >>
>> >> "Any fool can know. The point is to understand." - Albert Einstein
>> >>
>> >>
>> >
>> > --
>> > View this message in context:
>> http://old.nabble.com/html-snippet-in-cell-tp28621654p28623184.html
>> > Sent from the POI - User mailing list archive at Nabble.com.
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
>> > For additional commands, e-mail: user-h...@poi.apache.org
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
>> For additional commands, e-mail: user-h...@poi.apache.org
>>
>>
>
>
--
View this message in context:
http://old.nabble.com/html-snippet-in-cell-tp28621654p28623864.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
