Reading excel files in folder by giving folder name as input

[A Chauhan]

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]

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]

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.