Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners create folders and sub folders based on excel data

Have Programming Question? Ask it here!
 
 
 


Mallesham
create folders and sub folders based on excel data
0 Answer(s)      3 years and 3 months ago
Posted in : Java Beginners


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

Advertisement
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
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
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
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
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
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
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
Round Cube
Round Cube       Ajax based webmail client, has the basic functionality of the webmail (send mails, fwd, reply, folders, ...) Read full Description
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
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 get sub category based on category from database using jsp and javascript.
How to get sub category based on category from database using jsp and javascript.  How to get sub category based on category from database using jsp and javascript
read data from Excel sheet
read data from Excel sheet  Hi, How to read data from an excel sheet using JSP. Thank you
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 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
how to create an excel file using java
how to create an excel file using java  how to create an excel file using java
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
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
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
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
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
php import data from excel to mysql
php import data from excel to mysql  php import data from excel to mysql
Need to get the Data based on Date
Need to get the Data based on Date  Hie , I am having a criteria where i need to get the data based on date . I have written the query as "from Balance as b where b.date like ?" But the date field in DB is in datetime2 format
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
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
Retrieving specific data from excel
Retrieving specific data from excel  Hello everyone, i have written a simple code to retrieve data from excel sheet and working fine, the excel file contain heading for each row written in bold and the student details
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
Directory Structure of Artifactory-1.2.2
Directory Structure of Artifactory-1.2.2       Here are the folders that are shipped...;/etc/artifactory folder?. data: Includes the derby database files
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
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
Dynamic table data to Excel in JSP
Dynamic table data to Excel in JSP   Iam trying to export dynamic data to excel . But it is displaying only static data .Kindly help viewtrial.jsp.../vnd.ms-excel"); response.setHeader("Content-Disposition", "inline
java + excel data +graph - JDBC
java + excel data +graph  i am doin' a project in which i need to take up data from excel sheets and work upon them mathematically and finally draw a graph with the facility of drawing a trendline(in the graph)...also i need
Export Extjs Gridview data to excel in jsp
Export Extjs Gridview data to excel in jsp  i need to export the extjs girdview data to excel can you please help me thanks in advance
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
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
JavaScript get excel file data
JavaScript get excel file data...; By the use of JavaScript we can get the excel file data as well. Here is the example which gets the data from the excel file with the cell and row index
Sub Namespace
Declaring sub-namespace: We all are familiar with the directory structure or the tree of the file and folders, similarly we can get the nested or sub namespaces in PHP, this technique helps us to achieve more manageability. If you
We just have one file on the hard disk. But we can create directories, sub-directories and files in that file only
We just have one file on the hard disk. But we can create directories, sub-directories and files in that file only  We just have one file on the hard disk. But we can create directories, sub-directories and files in that file
We just have one file on the hard disk. But we can create directories, sub-directories and files in that file only
We just have one file on the hard disk. But we can create directories, sub-directories and files in that file only  We just have one file on the hard disk. But we can create directories, sub-directories and files in that file
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
Printing data into Excel sheet - Java Beginners
Printing data into Excel sheet  Hi all i am writing one application where there is need to bring the data into "Excel Sheet" with proper format.My... database then showing it(data) to in "Excel Sheet" is it possible to do ? if yes
How to import data from sql server table into an excel file by creating the rows dynamically in the excel according to the dataabase??
How to import data from sql server table into an excel file by creating... data from sql server table into an excel file by creating the rows dynamically... to create an excel file according to that and keep updating the same
read excel data from jsp - JSP-Servlet
read excel data from jsp  Hi how to read excel file from jsp? Excel file is created manually entered data having many sheets? and read the entire...)excel.jsp: Read And Edit Excel File  continue
reading data from excel file and plotting graph
the data in excel file, i have to plot graphs based on CELL ID selected. please help...reading data from excel file and plotting graph  I am doing a project... that reads an excel file using POI api and using the data of excel file
Advertisements
 

 

 

DMCA.com