File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Reading excel files in folder by giving folder name as input
Joined: Nov 21, 2006
Jan 29, 2009 01:34:36
I have to read some
files from a folder. Can anyone have an idea to give
input as folder name
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
Joined: Mar 22, 2005
Jan 29, 2009 01:51:17
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.
Joined: Oct 08, 2006
Jan 29, 2009 05:51:15
As he is posting this at the
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
or web start application for this.
I agree. Here's the link:
subject: Reading excel files in folder by giving folder name as input
Reading excel file from relative path
Read Excel values and store in to Database
Query Regarding Reading Excel files at Runtime
Read a .xls,.xlsx file format using XSSF
servlet beginner confused
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015