Re: convert wicket pages html to excel
HI there That exactly what i want to do .I want to convert html to excel.But i have not found a converter which supports to do that.I know there are many excel converter http://www.rasteredge.com/how-to/csharp-imaging/excel-converting/ .Is there any free package for this? Thanks for any suggestions. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p4663197.html Sent from the Users forum mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
RE: convert wicket pages html to excel
I also have some servlets whose html is created dynamically based on user input, its basically a form engine which creates forms dynamically ,developed several years before , its a servlet which writes to response reading form data from database, now I want to read the same servlet and create an excel, I donot have data to create excel using any api, I just have html and that I wan to convert to excel. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134129.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
Can you use the XML spreadsheet format? If so, you could perhaps (if your html is clean enough) use XSLT. On Fri, May 7, 2010 at 9:03 AM, fachhoch fachh...@gmail.com wrote: I also have some servlets whose html is created dynamically based on user input, its basically a form engine which creates forms dynamically ,developed several years before , its a servlet which writes to response reading form data from database, now I want to read the same servlet and create an excel, I donot have data to create excel using any api, I just have html and that I wan to convert to excel. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134129.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
well I will clean my html using htmlparsers and make it well formed xml , are there any example of using xslt to create excel out of xml ? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134216.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
I would perhaps try reverse-engineering it (that's what I did). You can save a spreadsheet as XML Spreadsheet and look at the XML (it's not pretty). On Fri, May 7, 2010 at 9:56 AM, fachhoch fachh...@gmail.com wrote: well I will clean my html using htmlparsers and make it well formed xml , are there any example of using xslt to create excel out of xml ? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134216.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
It sounds very brittle to take HTML output from an old HTML-generating servlet, cleaning it with a parser, making it valid XML, and then transforming it into different XML which will represent a spreadsheet. Is it really that difficult to obtain the data from the DB, push it into either a) clean xml representing the spreadsheet, or b) directly into jexcel or poi api? -- Jeremy Thomerson http://www.wickettraining.com On Fri, May 7, 2010 at 8:56 AM, fachhoch fachh...@gmail.com wrote: well I will clean my html using htmlparsers and make it well formed xml , are there any example of using xslt to create excel out of xml ? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134216.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
Well, in my case, it was difficult, because the users wanted to be able to turn *any* page in our application into a spreadsheet representation. Having to maintain two different versions of each page would be a maintenance nightmare, IMHO. On Fri, May 7, 2010 at 11:57 AM, Jeremy Thomerson jer...@wickettraining.com wrote: It sounds very brittle to take HTML output from an old HTML-generating servlet, cleaning it with a parser, making it valid XML, and then transforming it into different XML which will represent a spreadsheet. Is it really that difficult to obtain the data from the DB, push it into either a) clean xml representing the spreadsheet, or b) directly into jexcel or poi api? -- Jeremy Thomerson http://www.wickettraining.com On Fri, May 7, 2010 at 8:56 AM, fachhoch fachh...@gmail.com wrote: well I will clean my html using htmlparsers and make it well formed xml , are there any example of using xslt to create excel out of xml ? -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-excel-tp2131919p2134216.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
+1 for POI ;) Žilvinas Vilutis Mobile: (+370) 652 38353 E-mail: cika...@gmail.com On Wed, May 5, 2010 at 10:36 PM, Igor Vaynberg igor.vaynb...@gmail.com wrote: +1 for poi, used it, worked great -igor On Wed, May 5, 2010 at 10:31 PM, Adrian Wiesmann awiesm...@somap.org wrote: On 5/6/10 3:42 AM, Jeremy Thomerson wrote: I've done this before. I'd actually suggest not doing this. Use jexcel [1] - it is much more reliable and you won't have users calling you saying this spreadsheet won't open. I've written CSV before but then changed to Apache POI because of all those spreadsheet apps out there interpreting the separator character differently by default... Cheers, Adrian - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
Sometime ago, I have used both POI and jexcelAPI and I do prefer the later. At least at that time, they both had the same limitation: Excel file had to be generated in memory, which could be costly in terms of server side resources. If I recalled it correctly the problem with CSV was MS Excel interpretation of CSV was not the default CSV definition. So, I remember having implemented options to export content the MS way and the default way. Ernesto I've written CSV before but then changed to Apache POI because of all those spreadsheet apps out there interpreting the separator character differently by default... Cheers, Adrian - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
RE: convert wicket pages html to excel
Instead of templinging out html, template out xml and call it file.xls. There is a dom for spreadsheets. -Original Message- From: studentenaufinformatik [mailto:studentenaufinforma...@gmail.com] Sent: Wednesday, May 05, 2010 5:40 PM To: users@wicket.apache.org Subject: convert wicket pages html to excel we were converting our wicket html pages to pdf using flying saucer. Now our client is asking to convert into excel , I donot know any thing which does this , please suggest me if any body knows to convert html to excel on fly. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-exce l-tp2131919p2131919.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
I've done this before. I'd actually suggest not doing this. Use jexcel [1] - it is much more reliable and you won't have users calling you saying this spreadsheet won't open. [1] - http://jexcelapi.sourceforge.net/ -- Jeremy Thomerson http://www.wickettraining.com On Wed, May 5, 2010 at 8:26 PM, Tim L Casey tca...@cataphora.com wrote: Instead of templinging out html, template out xml and call it file.xls. There is a dom for spreadsheets. -Original Message- From: studentenaufinformatik [mailto:studentenaufinforma...@gmail.com] Sent: Wednesday, May 05, 2010 5:40 PM To: users@wicket.apache.org Subject: convert wicket pages html to excel we were converting our wicket html pages to pdf using flying saucer. Now our client is asking to convert into excel , I donot know any thing which does this , please suggest me if any body knows to convert html to excel on fly. -- View this message in context: http://apache-wicket.1842946.n4.nabble.com/convert-wicket-pages-html-to-exce l-tp2131919p2131919.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
On 5/6/10 3:42 AM, Jeremy Thomerson wrote: I've done this before. I'd actually suggest not doing this. Use jexcel [1] - it is much more reliable and you won't have users calling you saying this spreadsheet won't open. I've written CSV before but then changed to Apache POI because of all those spreadsheet apps out there interpreting the separator character differently by default... Cheers, Adrian - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: convert wicket pages html to excel
+1 for poi, used it, worked great -igor On Wed, May 5, 2010 at 10:31 PM, Adrian Wiesmann awiesm...@somap.org wrote: On 5/6/10 3:42 AM, Jeremy Thomerson wrote: I've done this before. I'd actually suggest not doing this. Use jexcel [1] - it is much more reliable and you won't have users calling you saying this spreadsheet won't open. I've written CSV before but then changed to Apache POI because of all those spreadsheet apps out there interpreting the separator character differently by default... Cheers, Adrian - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org