[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: html snippet in cell
From:       David Fisher <dfisher () jmlafferty ! com>
Date:       2010-05-20 16:55:54
Message-ID: 90E0FF78-B9A3-42C4-B766-C8F70E2D1A58 () jmlafferty ! com
[Download RAW message or body]

Recently a contribution was made to generate HTML to render Excel according to the style. This might be useful in understanding how HTML/CSS might be converted into Excel.

https://issues.apache.org/bugzilla/show_bug.cgi?id=49066

Regards,
Dave

On May 20, 2010, at 9:48 AM, MSB wrote:

> 
> 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
>> <dfisher@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-unsubscribe@poi.apache.org
>>>> For additional commands, e-mail: user-help@poi.apache.org
>>>> 
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@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-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]