create folders and sub folders based on excel data

create folders and sub folders based on excel data

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
View Answers









Related Tutorials/Questions & Answers:
create folders and sub folders based on excel data
create folders and sub folders based on excel data  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
Error in reading Excel data using jsp even having .xls and POI Library in respective folders
Error in reading Excel data using jsp even having .xls and POI Library in respective folders  Hi, hello.xls and POI library files are there in respective folders. the printStackTrce() method shows the following Error message
Advertisements
sorting folders automatically
sorting folders automatically  i want to sort folders automatically,let say the folders to be displayed in a webpage(hyperlinked to its resource).the page should display only the folder that belongs to last 15 days.it should
Java sdk/java poi hssf code to creat excel with folder structure,( i,e folders, subfolders and childrens )
Java sdk/java poi hssf code to creat excel with folder structure,( i,e folders, subfolders and childrens )   I need to create a folder structure... to create a folder structure in the excel file . To be precise, am working
ModuleNotFoundError: No module named 'split-folders'
ModuleNotFoundError: No module named 'split-folders'  Hi, My... 'split-folders' How to remove the ModuleNotFoundError: No module named 'split-folders' error? Thanks   Hi, In your python
how to hide and unhide folders in java
how to hide and unhide folders in java   i want to hide folder along with its contents and unhide later
java program to take backup for the folders
java program to take backup for the folders  java program to take backup for the folders   Have a look at the following link: Java Copy one folder to another
code for serching files and folders
code for serching files and folders  i want to create a code in java in which i can search any file or folder present on my local machine... and location...and one more thing we have to create new thread for each file
ModuleNotFoundError: No module named 'compare-files-folders'
ModuleNotFoundError: No module named 'compare-files-folders'  Hi...: No module named 'compare-files-folders' How to remove the ModuleNotFoundError: No module named 'compare-files-folders' error? Thanks   Hi
ModuleNotFoundError: No module named 'compare-files-folders'
ModuleNotFoundError: No module named 'compare-files-folders'  Hi...: No module named 'compare-files-folders' How to remove the ModuleNotFoundError: No module named 'compare-files-folders' error? Thanks   Hi
ModuleNotFoundError: No module named 'compare-files-folders'
ModuleNotFoundError: No module named 'compare-files-folders'  Hi...: No module named 'compare-files-folders' How to remove the ModuleNotFoundError: No module named 'compare-files-folders' error? Thanks   Hi
ModuleNotFoundError: No module named 'compare-files-folders'
ModuleNotFoundError: No module named 'compare-files-folders'  Hi...: No module named 'compare-files-folders' How to remove the ModuleNotFoundError: No module named 'compare-files-folders' error? Thanks   Hi
ModuleNotFoundError: No module named 'flask_multiple_static_folders'
ModuleNotFoundError: No module named 'flask_multiple_static_folders'  ...: No module named 'flask_multiple_static_folders' How to remove the ModuleNotFoundError: No module named 'flask_multiple_static_folders' error
ModuleNotFoundError: No module named 'compare-files-folders'
ModuleNotFoundError: No module named 'compare-files-folders'  Hi...: No module named 'compare-files-folders' How to remove the ModuleNotFoundError: No module named 'compare-files-folders' error? Thanks   Hi
ModuleNotFoundError: No module named 'flask_multiple_static_folders'
ModuleNotFoundError: No module named 'flask_multiple_static_folders'  ...: No module named 'flask_multiple_static_folders' How to remove the ModuleNotFoundError: No module named 'flask_multiple_static_folders' error
ModuleNotFoundError: No module named 'girder-virtual-folders'
ModuleNotFoundError: No module named 'girder-virtual-folders'  Hi...: No module named 'girder-virtual-folders' How to remove the ModuleNotFoundError: No module named 'girder-virtual-folders' error? Thanks   Hi
Error mounting VirtualBox shared folders in an Ubuntu guest
Error mounting VirtualBox shared folders in an Ubuntu guest  Hi, I shared windows folder in linux from Oracle virtual box. This folder is coming in Ubuntu but when i click on it it gives following error: You dont have
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders'
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' ...: ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' How to remove the ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders'
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' ...: ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' How to remove the ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders'
ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' ...: ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders' How to remove the ModuleNotFoundError: No module named 'compare_man_pages_from_two_folders
java program to take the backup of folders and copy the folder in different location without deleting the existing one
java program to take the backup of folders and copy the folder in different location without deleting the existing one  java program to take the backup of folders and copy the folder in different location without deleting
Java Util Zip. Zip files/folders inside a folder, without zipping the original source folder.
Java Util Zip. Zip files/folders inside a folder, without zipping the original source folder.   import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.util.zip.ZipEntry; import
Export html data to excel
Export html data to excel  I am trying to export data from an html page to an excel sheet.Any advise
how to display data in excel sheet?
how to display data in excel sheet?  According to the user Id,some... there will be a button called excel download,and if we click the button data will be displayed in excel sheet.can you people please help me how to create
Create Excel Sheet Using JSP
create excel sheet using jsp       In this example we create excel sheet and insert...;%@ page contentType="application/vnd.ms-excel" %> : Here, we insert the data
save data in excel
save data in excel  hello sir, i'm new to this field i want to know can i save data in excel by html forms input,means if any one fill up form online then it is save offline in excel how can i do it can you give me solution sir
save data in excel
save data in excel  hello sir, i'm new to this field i want to know can i save data in excel by html forms input,means if any one fill up form online then it is save offline in excel how can i do it can you give me solution sir
how to create a jave version excel in jsp
how to create a jave version excel in jsp  I would like to create a java version excel in JSP. so the excel like document can be published... to save the data. questions: 1 can any body share some code samples
read data from Excel sheet
read data from Excel sheet  Hi, How to read data from an excel sheet using JSP. Thank you
jsp data in excel - JSP-Servlet
jsp data in excel  i have create jsp page which has button for excel.this calls jsp which contains code which has and then code for present data... and this query data has come from beans and using beans i put it in excel jsp in table
how to create an excel file using java
how to create an excel file using java  how to create an excel file using java
Zip Folder Using Java
and sub folders of a folder just to take less space. To do so we create two...; In this example we are going to create a zip folder and all files contained... is used to read stream of row bytes such as image data, for reading streams
Inserting data in Excel File - Java Beginners
Inserting data in Excel File  Dear Sir, How can we fill the excel with fetched data from the database like Oracle, DB2? Is it possible to create an excel with filled data? Kindly give me the solutions to questions
Create SpreadSheet same as excel using java applet
Create SpreadSheet same as excel using java applet  Hi Ji, May i know to create new excel sheet using java Applet
Create SpreadSheet same as excel using java applet
Create SpreadSheet same as excel using java applet  Hi Ji, May i know to create new excel sheet using java Applet
Create Bar Graph from reading excel sheet in Java
Create Bar Graph from reading excel sheet in Java  I'm New to Java and I have to create a java program where I have to read data from multiple excel... in the different excel sheets (data can change and based on that graph should also get
Error in reading Excel data using jsp
Error in reading Excel data using jsp  ERROR while executing bellow...: drive?If not then create it.Anyways do you have POI library in the lib folder... and POI library files are there in respective folders. the printStackTrce
php import data from excel to mysql
php import data from excel to mysql  php import data from excel to mysql
jsp with excel sheet data uploading into database
jsp with excel sheet data uploading into database  how to upload data in excel sheet with jsp into oracle 10g database
Do data scientists use Excel?
Do data scientists use Excel?  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: Do data... that I can learn the topic "Do data scientists use Excel?". Also tell me
create html of word ,excel,ppt - JSP-Servlet
create html of word ,excel,ppt  Plzz tell me how to create html page of word , excel ,ppt document dynamically using jsp because in my project I have to store uploaded files as html page
How to Create New Excel Sheet Using JSP
How to create new excel sheet using jsp  ... a new  excel sheet using java .You can create any number of  new excel sheets in a excel file.  To create a excel sheet we can use third party APIs
Create Excel Sheet Using JSP
create excel sheet using jsp       In this program, we are going to create the cells and rows into excel sheet using java .You can create any number of cells and rows
ModuleNotFoundError: No module named 'django-excel-data-sync'
ModuleNotFoundError: No module named 'django-excel-data-sync'  Hi...: No module named 'django-excel-data-sync' How to remove the ModuleNotFoundError: No module named 'django-excel-data-sync' error? Thanks   Hi
extract data from excel sheet to mysql
extract data from excel sheet to mysql  sir, i want to extract data from excel sheet and save the data in mysql5.0 database in the form of table
Create and Save Excel File in JSP
Create and Save Excel File in JSP  ... to create a new  excel sheet using JSP. Our application consists of two JSP files. Java program allows to you to create any number of excel sheets in an excel
How to Create Excel Page Using JSP
how to create excel page using jsp       In this program, we are going to create an excel... using pure word files using Java. We can create, read or write MS Excel file using
connection of java file to excel file and put data from excel file into oracle db
connection of java file to excel file and put data from excel file into oracle db  how to create button on excel sheet using java swing and how we... as wellas to oracle db to insert excel data into database
exporting data to excel sheet - JDBC
exporting data to excel sheet  Sir i have already send request about... query in java swing program,i want to print the result about the query in excel...; Form(){ String data[][] = {{"",""}}; String col[] = {"Name
excel parsing and print data in the form of table
excel parsing and print data in the form of table  my reqment is i have to parse the excel and i need to print the data in the table by using swing jtable or else ....can u give the solution please

Ads