I need to develop a web application in java using net beans ide that reads both open office spread sheet data and excel spread sheet data that means it should read the data with xls,xlsx and ods extensions.I have an excel sheet with 13 columns which has date,names etc.my main requirement is to choose a file using file uploader and insert the data in database and display it in gridview after inserting.How can i do this i am very new to this can any one help me out
Let's level set a little bit more. How much Java do you know? Do you know how to create a web app? Do you know how to read data from a spreadsheet? Do you know how to eat an elephant? (Answer: One bite at a time)
If that last question seemed odd, it's meant to be an analogy. Don't try to tackle a big problem all at once. Break it down into smaller, more manageable chunks. That way, you don't bite off more than you can chew and you won't end up in the hospital with indigestion or worse.
I dont know because i am very new to this,my first thing is to choose a excel sheet of .ods extension,xls or xlsx extension from my desktop and insert the data in database after clicking upload button and displa y the uploaded data in a gridview that is what i need
What you are describing is a non-trivial program. Again, tell us how much exactly you know about Java. If you know nothing at all then I think you need to have a reality check and tackle a problem that's more n line with your skill level. This is not something you should try to do if you're still very new to Java.
i am a freasher in java and moreover i am able to choose the file using file uploader but after choosing i want to read the data in excel sheet and insert in database for xls,xlsx and ods extension i could not find code for this
There isn't just some code for this, it's the entire way you code your program. Here is some examples of how you would use POI. If this code is confusing to you, you probably should work on becoming a more experienced Java programmer first.
All things are lawful, but not all things are profitable.