How to read an excel file and create a directory structure
Joined: Sep 19, 2007
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.
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.
Googling doesn't make you a genius. But not Googling makes you dumber.