Fetching file Name,file Path and size from directories and exporting them to excel sheet.

                  In this tutorial we will explore the usage of File input & output operations.we will take a small requirement to learn the concept. Basic requirement that we are dealing in this tutorial is that when user enter the path of the parent directory,we need to get into that parent directory and pull out all the file names,file path and size of the files.we need to extract the files in the sub-directory as well.To make user task of tracking down the file details we are providing the o/p in the form of excel sheet.

                 By the end of the tutorial you will be able to Fetching file Name,file Path and size from directories and exporting them to excel sheet using Java programming language.

In order to complete this project we need.

• Java 1.5 or above.
• IDE for making things easy(optional) I am using eclipse for my convince.
• jxl jar file(click here to download jxl jar).
• MS excel to show the output.

steps to achieve this requirement.

• create a java project in the IDE.
• create two class with names client class and logic class.
• add the jxl jar to the project.(Right click on the project and go to build path ->configure build path. as shown in the figure.
  
• add the jxl jar by clicking on the add external jar in the library tab in the top section.

Code

	=============================================ClientClass =============================================
	import java.util.List;
	import java.util.Scanner;
	import jxl.write.WriteException;
	public class ClientClass {
	public static void main(String[] args) {
	//declaring scanner to get the input form the user through the keyboard
	//system.in is used to get the i/p through the keyboard from user
	Scanner sc=new Scanner(System.in);
	String path,excelPath;
	System.out.println("Enter the path from which u want to get the all filenames");
	//getting path of the directory.
	path=sc.nextLine();
	System.out.println("path value is"+path);
	//getting path of excel sheet to which they want to extract the files info
	System.out.println("Enter the excel path from which u want to get the all filenames");
	excelPath=sc.nextLine();
	System.out.println("path value is"+excelPath);
	//declaring the list to get fileName,path and size
	List<String> value=LogicClass.listf(path);
	try{
	// calling a static method readExcel and sending excel sheet path as a parameter.
	LogicClass.readExcel(excelPath);
	//calling a static method setValueIntoCell and sending cell co-ordiantes x,y along with value at cell(x,y).
	LogicClass.setValueIntoCell( 0, 0, "FileName");
	LogicClass.setValueIntoCell( 1, 0, "FilePath");
	LogicClass.setValueIntoCell( 2, 0, "FileSize");
	for(int i=0,j=0,k=1;i<(Math.round(value.size())/3);i++,k++){
	//logic for getting string from the list
	//calling a static method setValueIntoCell and sending cell co-ordiantes x,y along with value at cell(x,y).
	LogicClass.setValueIntoCell(0, k,value.get(j));
	j++;
	LogicClass.setValueIntoCell(1, k,value.get(j));
	j++;
	LogicClass.setValueIntoCell(2, k,value.get(j));
	j++;
	}
	}
	catch(WriteException we){
	System.out.println("could not write the content into the excel file");
	}
	LogicClass.closeFile();
	}
	}

view raw client class hosted with ❤ by GitHub

	import java.io.File;
	import java.io.FileNotFoundException;
	import java.util.*;
	import java.io.File;
	import jxl.Workbook;
	import jxl.write.WritableSheet;
	import jxl.write.WritableWorkbook;
	import jxl.write.Label;
	import jxl.write.WriteException;
	public class LogicClass {
	static Workbook workbook;
	static WritableWorkbook writableWorkBook;
	static WritableSheet sSheet;
	static List<String> contentList=new ArrayList<String>();
	public static List<String> listf(String directoryName) {
	//declaring the file and passing directory path as parameter
	File directory = new File(directoryName);
	// get all the files from a directory
	File[] fList = directory.listFiles();
	try{
	for (File file : fList) {
	if (file.isFile()) {
	//prints the file.getName() ,file.getAbsolutePath() and file.length() if it is an file.
	System.out.println(file.getName()+"||||"+file.getAbsolutePath()+"||||"+file.length());
	//adding file.getName() ,file.getAbsolutePath() and file.length() to content list
	contentList.add(file.getName());
	contentList.add(file.getAbsolutePath());
	contentList.add(file.length()+"");
	}
	else if (file.isDirectory()) {
	//passing the path again into function to print the files in sub directory
	listf(file.getPath()); //using recursion function
	}
	}
	}
	//
	catch(NullPointerException npe){
	System.out.println("directory/file not found");
	}
	return contentList;
	}
	//excel code to read file
	public static void readExcel(String excelpath)
	{
	try{
	//getting the access to the workbook
	workbook = Workbook.getWorkbook(new File(excelpath));
	//creating a workbook to write the content
	writableWorkBook = Workbook.createWorkbook(new File(excelpath), workbook);
	sSheet = writableWorkBook.getSheet(0); //getsheet(0)=> that content will be written into the sheet1
	}
	//handling if file is not found
	catch(FileNotFoundException fnfe){
	System.out.println("plese give the corrrect path fort the file");
	}
	catch(Exception e)
	{
	System.out.println("error occured");
	}
	}
	public static void setValueIntoCell(int iColumnNumber, int iRowNumber,String strData) throws WriteException
	{
	WritableSheet wshTemp = writableWorkBook.getSheet(0);
	Label labTemp = new Label(iColumnNumber, iRowNumber, strData);
	try {
	//adding cell value to cell co-ordinates (x,y) ie cell(iColumnNumber, iRowNumber) with value strdata
	wshTemp.addCell(labTemp);
	}
	catch (Exception e)
	{
	System.out.println("error occured");
	}
	}
	public static void closeFile()
	{
	try {
	// Closing the writable work book
	writableWorkBook.write();
	writableWorkBook.close();
	// Closing the original work book
	workbook.close();
	} catch (Exception e)
	{
	System.out.println("error occured while closing the file");
	}
	}
	}

view raw LogicClass hosted with ❤ by GitHub

• now copy the code into the respective classes and go through the follow by reading the comments.
• save the project and run the project.give the directory path and excel path to which you want to save the content.
• note:-every time give new excel sheet so that details will not override.

thats it from this tutorial ..... hope you liked it. like,share and comment.

Share on Google Plus

About Sandeep Ram