This week's book giveaway is in the Reactive Progamming forum.
We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line!
See this thread for details.
Win a copy of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams this week in the Reactive Progamming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

import JSP table to excel

 
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
 
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.
 
Rancher
Posts: 43011
76
  • 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: 43011
76
  • 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
 
God is a comedian playing for an audience that is afraid to laugh - Voltair. tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!