Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / October 2005

Tip: Looking for answers? Try searching our database.

need to extract data from an html page into a csv file (txt)

Thread view: 
MUK - 21 Oct 2005 13:58 GMT
Hi

Here is a functionality that I need to build into my J2EE webapp (built
on IBM's EAD4J framework) ...

A page is displayed in html which looks like a spreadsheet. I need to
build this functionality into this page... if the user wants, the user
can export all the data displayed on this html page into a csv file
which the user can save locally and import into something like
excel....

any thoughts?

thanks a million!!

uk
Andrew Thompson - 21 Oct 2005 14:27 GMT
> Here is a functionality that I need to build into my J2EE webapp (built
> on IBM's EAD4J framework) ...
>
> A page is displayed in html which looks like a spreadsheet. I need to
> build this functionality into this page...

What functionality?  Depending on the level, HTML/JS
might be quite enough to achieve it.

>..if the user wants, the user
> can export all the data displayed on this html page into a csv file
> which the user can save locally and import into something like
> excel....

Try this for a thought.  After 'functionalising' the data,
the user can post it to a second page that is either..
- a plain HTML table, with a link below to the same as CSV, or..
- the CSV file itself.  Most browsers will offer to save a CSV file,
  though your poor IE users might need instructions, as IE would
  likely open the CSV in whatever program is registered to handle
  a CSV file (often Excel).
Roedy Green - 22 Oct 2005 01:48 GMT
>A page is displayed in html which looks like a spreadsheet. I need to
>build this functionality into this page... if the user wants, the user
>can export all the data displayed on this html page into a csv file
>which the user can save locally and import into something like
>excel....

That could be an HTML table. You might check the CSS newsgroups for
discussions of how to have non-scrolling headers and footers, a cause
of much teeth gnashing.

You could do the display with a JTable Applet with a local cache of
rows backed by the server.  If the table is large, this is what you
will need.

To export the CSV you could have a button that downloads a virtual
file you compose.  See http://mindprod.com/jgloss/csv.html

You could also have the signed Applet or JAWS Applet/application
create the CSV file.  That would be faster since the Applet would
already have most of the data and the data could be sent to the Applet
in compressed from rather than as a raw CSV.

If that makes your head ache, I am open for contract work.
Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Again taking new Java programming contracts.



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.