Thanks Nick , but here I multiple html files , and one master excel file , where it references the other html files in the same directory, if you can tell me a way to append all the renamed html files in to one , my job is done.I appreciate your help.
Thanks Nick Burch wrote: > > On Sun, 21 Oct 2007, pradeepbill wrote: >> I have some HTML code as below and , if I copy paste that in an EXCEL >> file , I can see a proper page , now can I use APACHE POI to do such a >> thing automatically ? I tried to create a cell with all the HTML code as >> a HSSFRichTextString , but I just see the HTML code as it is...Please >> let me know if this is possible. > > You'll need to use a html parsing library to get the contents of your page > out, then loop over it and create rows/cells as needed with poi > > Alternately, why not just have excel load up the html file? As long as you > rename your .html file to .xls, and it contains a table, excel ought to be > able to load the data for you > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/html-to-excel-tf4667007.html#a13349414 Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
