how to extract data from web pages which is in tabular form to an xl sheet
like data is in the form of tabular form <table> <tr> name </tr> like this hoe to store that name data into xl sheet programatically on clicking some button [ June 26, 2006: Message edited by: Bear Bibeault ]
Hey I hope you can figure out how to read data from the table on the webpage.
Once you are done with the reading part below is the approach for writing an excel sheet
just read the data from the web page and write it on the excel sheet by setting the content type to ms-excel eg - response.setContentType("application/vnd.ms-excel")
Now to write it on the excel you have two options - 1. do it like u write a table dynamically in jsp, but in this case the format of excel sheet will not be in your control. trust me this is easy but of no good.
2. Use Apache poi project for excel sheet . download the api give it classpath and then use the api in the servlet. Why servlet because jsp will not allow you to write the data on the excel sheet even though it wont give an error. Writing a servlet wont be tough.
below is the eg. for writing excel using servlet -
Originally posted by Abhilash Boinapally: Thankz for ur reply
Abhilash Boinapally, JavaRanch is a community of people from all over the world, many of who are not native English speakers. While using abbreviations like "u" instead of spelling out "you" is convenient when text messaging your friends on a cell phone or in a chat room, it presents an extra challenge to those that are already struggling with English. Additionally, such shortcuts may confound automated translation tools that patrons of the Ranch may be making use of.
I would like to ask for your help in making the content of JavaRanch a little easier to read for everybody that visits here by not using such abbreviations.