Win a copy of Learn Spring Security (video course) this week in the Spring 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
Pie
Posts: 42967
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