Hi,
i have a requirement that , read the data from excel sheet and based on that data i need to create folders and subfolders.
here the excel sheet looks like this:

**Parent_folder   Sub_Folder1        Sub_Folder2**

        Bank    Department  Banking
                            Insurance

                 months     Jan
                            Feb

        Test     Types      Savings
                            Current
form this excel sheet how can i read the data line by line and based on that how can i create folder structure same as the excel sheet?
if excel sheet have the all column values i will do this through POI jar, but here 1st row i have all values so i can achieve this easily, but for next 2 sub folders, the parent folder is same, so the parent column is null but i need to take the Bank value only.

so how can i achieve this through java code.

any help in this would be highly appreciated.

thankas in advance