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] > >
