How to read an excel file and create a directory structure

[Foni kumar]

Hi Experts,

Please suggest How can I read and excel and create a recursive folder structure in my system automatically using java. Suppose I have a list of folder structures present in the column named FOLDER STRUCTURE in my excel sheet like C://folder1 ,C://folder2, C://folder1//folder2//folder3 ,C://folder4 and so on. It has got some 100 entries say

How can I read the excel and create the folder structure in the recursive form. Kindly suggest for any ideas or reference links which will be helpful.

Thanks and Regards,
D

[Prabaharan Gopalan]

There are two parts to this problem:
1. Read the value from Excel (for which you might want to look up ODBC and how it's done).
2. Create the directory from what you've read (traditionally java.io and if you're curious, java.nio).

Let us know when you attempted these and whether these worked.

[Sachin Joshi]

I guess you need to do following

1. Use a Library like POI from Apatche to read the excel file

2. Then use File IO Library like Apache Commons - IO to created the directory structure.


Hope this helps

[Campbell Ritchie]

Question too difficult for “beginning”; moving discussion.