aspose file tools*
The moose likes Other Open Source Projects and the fly likes import JSP table to excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "import JSP table to excel" Watch "import JSP table to excel" New topic
Author

import JSP table to excel

Abhradeep Banerjee
Ranch Hand

Joined: Dec 09, 2009
Posts: 71
Hi,

Is there a way i can code so that i am able to import the table from JSP into excel. prefer if im able to do it in c#
Regards
Trendnet18
Bojan Tomic
Greenhorn

Joined: Apr 08, 2008
Posts: 25
What do you mean "JSP table"? Are you talking about a html element called <table>?
In that case, there's nothing JSP specific. If you know how to parse html in C#, that's it.
If you were talking about JSP outputting something that can be readily imported into Excel, well, that's doable too, but you'd have to know the format. If csv is enough, go with that.
If you need real Excel export, look at Seam, it has excel export freature:
http://myjavaroom.blogspot.com/2009/10/microsoft-excel-spreadsheet-in-jboss.html
http://myjavaroom.blogspot.com/2009/12/jboss-seam-excel-implementation-part-2.html
Looking further into that would be waaay beyond this topic and forum.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41905
    
  63
Question about how to do something in C# would be better suited for a C# forum than JavaRanch :-)

Excel can indeed import HTML files containing TABLE elements, although I personally wouldn't want to rely on that. As Bojan said, CSV would be a better option (or use a library such as Apache POI to create proper XLS/XLSX files).


Ping & DNS - my free Android networking tools app
Abhradeep Banerjee
Ranch Hand

Joined: Dec 09, 2009
Posts: 71
is there a mining tool i can use to download the info?
thats actually what im trying to do is transfer the info and update it
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41905
    
  63
HtmlUnit is good for scraping web sites. Make sure that what you're intending to do is legal - most web sites put restrictions on the use of their content.
Abhradeep Banerjee
Ranch Hand

Joined: Dec 09, 2009
Posts: 71
yeah totally legal already checked with them
Abhradeep Banerjee
Ranch Hand

Joined: Dec 09, 2009
Posts: 71
is there a way to check if the table has an image?? eg level1.gif

doesn't matter which language it is in can be c# or java or vb
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: import JSP table to excel