package Package1;
import java.io.*;
import java.util.*;
import java.lang.*;


import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

//import java.io.FileInputStream;
//import java.io.FileNotFoundException;
//import java.io.IOException;
//import java.util.ArrayList;
//import java.util.Iterator;
//import java.util.List;

public class ReadFile {
	//private static final String FILE_PATH = "C:\\Users\\pankaj-sinha\\Desktop\\Desktop\\WorkArea\\DataSource.xlsx";
	
		 
	
		    public static void main(String args[]) throws Exception {
	
//		       try{
//		    	   FileInputStream f= new FileInputStream(new File ("C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource.xlsx"));
//		    	  Workbook wb=new XSSFWorkbook(f);
//		    	  Sheet firstsheet=wb.getSheetAt(0);
//		    	  Iterator<Row> iterator=firstsheet.iterator();
//		    	
//		    	  while (iterator.hasNext()){
//		    		  Row nextRow= iterator.next();
//		    		  Iterator<Cell> cellIterator=nextRow.cellIterator();
//		    		  
//		    		  while (cellIterator.hasNext()){
//		    			  Cell cell=cellIterator.next();
//		    			  
//		    			  switch (cell.getCellType()){
//		    			  case Cell.CELL_TYPE_STRING:
//		    				  System.out.println(cell.getStringCellValue());
//		    				  break;
//		    			  case Cell.CELL_TYPE_BOOLEAN:
//		    				  System.out.println(cell.getBooleanCellValue());
//		    				  break;
//		    			  case Cell.CELL_TYPE_NUMERIC:
//		    				  System.out.println(cell.getNumericCellValue());
//		    				  break;
//		    			  }
//		    			  System.out.print(" - ");		    			  
//		    		  }
//		    		  
//		    		  System.out.println();		    		  
//		    	  }
//		    	   
//		    	   System.out.println("File line passed");
//		    	   wb.close();
//		    	   f.close();
//		       }
//		       catch (Exception e){
//		    	   
//		    	   e.printStackTrace();	    	   
//		    	   
//		       }
		    	
		    	
//		    Code block to read the file------ Starts
		    	String excelFilePath = "C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource.xlsx";
		        FileInputStream inputStream = new FileInputStream(new File(excelFilePath));
			    
			    Workbook workbook = new XSSFWorkbook(inputStream);
		        Sheet firstSheet = workbook.getSheetAt(0);
		        Iterator<Row> iterator = firstSheet.iterator();
		         
		        while (iterator.hasNext()) {
		            Row nextRow = iterator.next();
		            Iterator<Cell> cellIterator = nextRow.cellIterator();
		             
		            while (cellIterator.hasNext()) {
		                Cell cell = cellIterator.next();
		                 
		                switch (cell.getCellType()) {
		                    case Cell.CELL_TYPE_STRING:
		                        System.out.print(cell.getStringCellValue());
		                        break;
		                    case Cell.CELL_TYPE_BOOLEAN:
		                        System.out.print(cell.getBooleanCellValue());
		                        break;
		                    case Cell.CELL_TYPE_NUMERIC:
		                        System.out.print(cell.getNumericCellValue());
		                        break;
		                }
		                System.out.print(" - ");
		            }
		            System.out.println();
		        }
		         
		        workbook.close();
		        inputStream.close();	    	
		    	
//		      Code block to read the file------ Ends
		        
//		        Write in Excel------ Starts
		        FileOutputStream fout=new FileOutputStream(new File("C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource1.xlsx"));
		        Workbook wb= new XSSFWorkbook ();
		        Sheet sheet = wb.createSheet("Java Books");
		         
		        Object[][] bookData = {
		                {"Head First Java", "Kathy Serria", 79},
		                {"Effective Java", "Joshua Bloch", 36},
		                {"Clean Code", "Robert martin", 42},
		                {"Thinking in Java", "Bruce Eckel", 35},
		        };
		 
		        int rowCount = 0;
		         
		        for (Object[] aBook : bookData) {
		            Row row = sheet.createRow(++rowCount);
		             
		            int columnCount = 0;
		             
		            for (Object field : aBook) {
		                Cell cell = row.createCell(++columnCount);
		                if (field instanceof String) {
		                    cell.setCellValue((String) field);
		                } else if (field instanceof Integer) {
		                    cell.setCellValue((Integer) field);
		                }
		            }
		             
		        }
		         
		         
		        try (FileOutputStream outputStream = new FileOutputStream("JavaBooks.xlsx")) {
		            workbook.write(outputStream);
		        
		        
//		        Write in Excel------ Ends
		        
		     }
}
}