This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading excel files in folder by giving folder name as input

 
A Chauhan
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have to read some excel files from a folder. Can anyone have an idea to give input as folder name and java will read all the excel files in that folder. Ultimately i have to import the data from those excels to oracle database.

Thanks in advance
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this question about how to access all files in a directory given the directory name, or about how to open XLS files?

If the former, check out the java.io.File.list() and listFiles() methods.

If the latter, check out the Apache POI library; it can read XLS files.
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As he is posting this at the JSP forum, I am afraid that he is talking about a folder at the client machine.

If this is true and you want to send the files from client to server using a web application, then you need a signed applet or web start application for this.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic