Rajendra Prakash wrote:Can you give me logic to read cells and store in to DB
No it doesn't work that way. What have you tried? What went wrong? What happened and what did you expect to happen?
And moving to Java in General.
But i want to convert this to "yyyy/mm/dd". i have tried with SimpleDateFormat class. But i could not get.
can you help me
Now i want to read multiple workbooks and store in to db. can you give me any logic for this.
There is a method that reads one file and stores something to the database - it sounds as if calling that method multiple times with different files would do the trick. Have you tried that? If so, what was the result? If not, tell us where you are stuck making progress.
If you're asking how a user can choose a file, start here: http://download.oracle.com/javase/tutorial/uiswing/components/filechooser.html
If you're asking something else, TellTheDetails. Your last two posts were very short, so it's hard to know what you have, and what problems you're encountering.
but now i want to read multiple excel files from single folder in a single line. i dont want to call "first" method again and again. which means i want call excel file dynamically.
Create a method that takes the name of the directory as parameter, and in that method iterate through all files in that directory. For each xls file you'd then call the first method.