madan712 · October 18, 2012 14:35 · whdals0 · May 4, 2020 · anupdey99 · Jan 11, 2021
diff --git a/ReadWriteExcelFile.java b/ReadWriteExcelFile.java
 import java.io.FileInputStream;
 import java.io.FileOutputStream;
 import java.io.IOException;
 import java.io.InputStream;
 import java.util.Iterator;

 import org.apache.poi.hssf.usermodel.HSSFCell;
 import org.apache.poi.hssf.usermodel.HSSFRow;
 import org.apache.poi.hssf.usermodel.HSSFSheet;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;

 import org.apache.poi.xssf.usermodel.XSSFCell;
 import org.apache.poi.xssf.usermodel.XSSFRow;
 import org.apache.poi.xssf.usermodel.XSSFSheet;
 import org.apache.poi.xssf.usermodel.XSSFWorkbook;

 public class ReadWriteExcelFile {

 	public static void readXLSFile() throws IOException
 	{
 		InputStream ExcelFileToRead = new FileInputStream("C:/Test.xls");
 		HSSFWorkbook wb = new HSSFWorkbook(ExcelFileToRead);

 		HSSFSheet sheet=wb.getSheetAt(0);
 		HSSFRow row; 
 		HSSFCell cell;

 		Iterator rows = sheet.rowIterator();

 		while (rows.hasNext())
 		{
 			row=(HSSFRow) rows.next();
 			Iterator cells = row.cellIterator();
 			
 			while (cells.hasNext())
 			{
 				cell=(HSSFCell) cells.next();
 		
 				if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING)
 				{
 					System.out.print(cell.getStringCellValue()+" ");
 				}
 				else if(cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC)
 				{
 					System.out.print(cell.getNumericCellValue()+" ");
 				}
 				else
 				{
 					//U Can Handel Boolean, Formula, Errors
 				}
 			}
 			System.out.println();
 		}
 	
 	}
 	
 	public static void writeXLSFile() throws IOException {
 		
 		String excelFileName = "C:/Test.xls";//name of excel file

 		String sheetName = "Sheet1";//name of sheet

 		HSSFWorkbook wb = new HSSFWorkbook();
 		HSSFSheet sheet = wb.createSheet(sheetName) ;

 		//iterating r number of rows
 		for (int r=0;r < 5; r++ )
 		{
 			HSSFRow row = sheet.createRow(r);
 	
 			//iterating c number of columns
 			for (int c=0;c < 5; c++ )
 			{
 				HSSFCell cell = row.createCell(c);
 				
 				cell.setCellValue("Cell "+r+" "+c);
 			}
 		}
 		
 		FileOutputStream fileOut = new FileOutputStream(excelFileName);
 		
 		//write this workbook to an Outputstream.
 		wb.write(fileOut);
 		fileOut.flush();
 		fileOut.close();
 	}
 	
 	public static void readXLSXFile() throws IOException
 	{
 		InputStream ExcelFileToRead = new FileInputStream("C:/Test.xlsx");
 		XSSFWorkbook  wb = new XSSFWorkbook(ExcelFileToRead);
 		
 		XSSFWorkbook test = new XSSFWorkbook(); 
 		
 		XSSFSheet sheet = wb.getSheetAt(0);
 		XSSFRow row; 
 		XSSFCell cell;

 		Iterator rows = sheet.rowIterator();

 		while (rows.hasNext())
 		{
 			row=(XSSFRow) rows.next();
 			Iterator cells = row.cellIterator();
 			while (cells.hasNext())
 			{
 				cell=(XSSFCell) cells.next();
 		
 				if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING)
 				{
 					System.out.print(cell.getStringCellValue()+" ");
 				}
 				else if(cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC)
 				{
 					System.out.print(cell.getNumericCellValue()+" ");
 				}
 				else
 				{
 					//U Can Handel Boolean, Formula, Errors
 				}
 			}
 			System.out.println();
 		}
 	
 	}
 	
 	public static void writeXLSXFile() throws IOException {
 		
 		String excelFileName = "C:/Test.xlsx";//name of excel file

 		String sheetName = "Sheet1";//name of sheet

 		XSSFWorkbook wb = new XSSFWorkbook();
 		XSSFSheet sheet = wb.createSheet(sheetName) ;

 		//iterating r number of rows
 		for (int r=0;r < 5; r++ )
 		{
 			XSSFRow row = sheet.createRow(r);

 			//iterating c number of columns
 			for (int c=0;c < 5; c++ )
 			{
 				XSSFCell cell = row.createCell(c);
 	
 				cell.setCellValue("Cell "+r+" "+c);
 			}
 		}

 		FileOutputStream fileOut = new FileOutputStream(excelFileName);

 		//write this workbook to an Outputstream.
 		wb.write(fileOut);
 		fileOut.flush();
 		fileOut.close();
 	}

 	public static void main(String[] args) throws IOException {
 		
 		writeXLSFile();
 		readXLSFile();
 		
 		writeXLSXFile();
 		readXLSXFile();

 	}

 }
	import java.io.FileInputStream;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.InputStream;
	import java.util.Iterator;

	import org.apache.poi.hssf.usermodel.HSSFCell;
	import org.apache.poi.hssf.usermodel.HSSFRow;
	import org.apache.poi.hssf.usermodel.HSSFSheet;
	import org.apache.poi.hssf.usermodel.HSSFWorkbook;

	import org.apache.poi.xssf.usermodel.XSSFCell;
	import org.apache.poi.xssf.usermodel.XSSFRow;
	import org.apache.poi.xssf.usermodel.XSSFSheet;
	import org.apache.poi.xssf.usermodel.XSSFWorkbook;

	public class ReadWriteExcelFile {

	public static void readXLSFile() throws IOException
	{
	InputStream ExcelFileToRead = new FileInputStream("C:/Test.xls");
	HSSFWorkbook wb = new HSSFWorkbook(ExcelFileToRead);

	HSSFSheet sheet=wb.getSheetAt(0);
	HSSFRow row;
	HSSFCell cell;

	Iterator rows = sheet.rowIterator();

	while (rows.hasNext())
	{
	row=(HSSFRow) rows.next();
	Iterator cells = row.cellIterator();

	while (cells.hasNext())
	{
	cell=(HSSFCell) cells.next();

	if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING)
	{
	System.out.print(cell.getStringCellValue()+" ");
	}
	else if(cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC)
	{
	System.out.print(cell.getNumericCellValue()+" ");
	}
	else
	{
	//U Can Handel Boolean, Formula, Errors
	}
	}
	System.out.println();
	}

	}

	public static void writeXLSFile() throws IOException {

	String excelFileName = "C:/Test.xls";//name of excel file

	String sheetName = "Sheet1";//name of sheet

	HSSFWorkbook wb = new HSSFWorkbook();
	HSSFSheet sheet = wb.createSheet(sheetName) ;

	//iterating r number of rows
	for (int r=0;r < 5; r++ )
	{
	HSSFRow row = sheet.createRow(r);

	//iterating c number of columns
	for (int c=0;c < 5; c++ )
	{
	HSSFCell cell = row.createCell(c);

	cell.setCellValue("Cell "+r+" "+c);
	}
	}

	FileOutputStream fileOut = new FileOutputStream(excelFileName);

	//write this workbook to an Outputstream.
	wb.write(fileOut);
	fileOut.flush();
	fileOut.close();
	}

	public static void readXLSXFile() throws IOException
	{
	InputStream ExcelFileToRead = new FileInputStream("C:/Test.xlsx");
	XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);

	XSSFWorkbook test = new XSSFWorkbook();

	XSSFSheet sheet = wb.getSheetAt(0);
	XSSFRow row;
	XSSFCell cell;

	Iterator rows = sheet.rowIterator();

	while (rows.hasNext())
	{
	row=(XSSFRow) rows.next();
	Iterator cells = row.cellIterator();
	while (cells.hasNext())
	{
	cell=(XSSFCell) cells.next();

	if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING)
	{
	System.out.print(cell.getStringCellValue()+" ");
	}
	else if(cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC)
	{
	System.out.print(cell.getNumericCellValue()+" ");
	}
	else
	{
	//U Can Handel Boolean, Formula, Errors
	}
	}
	System.out.println();
	}

	}

	public static void writeXLSXFile() throws IOException {

	String excelFileName = "C:/Test.xlsx";//name of excel file

	String sheetName = "Sheet1";//name of sheet

	XSSFWorkbook wb = new XSSFWorkbook();
	XSSFSheet sheet = wb.createSheet(sheetName) ;

	//iterating r number of rows
	for (int r=0;r < 5; r++ )
	{
	XSSFRow row = sheet.createRow(r);

	//iterating c number of columns
	for (int c=0;c < 5; c++ )
	{
	XSSFCell cell = row.createCell(c);

	cell.setCellValue("Cell "+r+" "+c);
	}
	}

	FileOutputStream fileOut = new FileOutputStream(excelFileName);

	//write this workbook to an Outputstream.
	wb.write(fileOut);
	fileOut.flush();
	fileOut.close();
	}

	public static void main(String[] args) throws IOException {

	writeXLSFile();
	readXLSFile();

	writeXLSXFile();
	readXLSXFile();

	}

	}