Hello David, The honest answer is I do not know, but thinking about it a little further and I would expect it to be rendered as simple text rather than interpreted as markup. It should be easy enough to test and, if I ever do manage to find out how to get headers and footers in Word documents working just as I want them, then I will take a quick look later tonight. Must admit though that i did rather like that macro and can see how it would be possible to create a little 'engine', for want of a better term, that we could pass the HTML into and rely on it to spit out at the other a rich text string which could be written into a cell. Initially, it's functionality would be quite limited but it sounds like an interesting little project for a rainy day.
Yours Mark B David Fisher 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: [email protected] >> For additional commands, e-mail: [email protected] >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/html-snippet-in-cell-tp28621654p28623382.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]
