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

M

MUK

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
 
A

Andrew Thompson

MUK said:
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).
 
R

Roedy Green

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top