import JSP table to excel

[Abhradeep Banerjee]

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]

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]

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]

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]

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]

yeah totally legal already checked with them

[Abhradeep Banerjee]

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