• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

import JSP table to excel

 
Abhradeep Banerjee
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Abhradeep Banerjee
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yeah totally legal already checked with them
 
Abhradeep Banerjee
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic