aspose file tools*
The moose likes JSP and the fly likes Reading excel files in folder by giving folder name as input Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Reading excel files in folder by giving folder name as input" Watch "Reading excel files in folder by giving folder name as input" New topic
Author

Reading excel files in folder by giving folder name as input

A Chauhan
Greenhorn

Joined: Nov 21, 2006
Posts: 15
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
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
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.


Ping & DNS - updated with new look and Ping home screen widget
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading excel files in folder by giving folder name as input
 
Similar Threads
Query Regarding Reading Excel files at Runtime
servlet beginner confused
Reading excel file from relative path
Read Excel values and store in to Database
Read a .xls,.xlsx file format using XSSF