import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.text.FieldPosition;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;

import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.Name;

public class SheetUpdate {

	public static void main(String[] args) {


			// TODO Auto-generated method stub
			File inpFile=null;
			FileInputStream file=null;
			OPCPackage pkg = null;
			Row row = null;
			try{
				
				inpFile = new File("D:\\Temp\\26 Apr 2019\\TestTemplate.xlsx");

				file = new FileInputStream(inpFile);

				pkg = OPCPackage.open(file);

				XSSFWorkbook workbook = new XSSFWorkbook(pkg);
				SXSSFWorkbook workbook_sx = new SXSSFWorkbook(workbook, 1000);
				workbook_sx.setCompressTempFiles(true);
				
				
				
				XSSFSheet vDataSheetXssf = workbook.getSheet("Sheet1");
				SXSSFSheet vDataSheetSxssf = (SXSSFSheet) workbook_sx.getSheet("Sheet1");
				
				
				Iterator<Row> rowIterator = vDataSheetXssf.iterator();
				int i=0;
				while(true)
				{
					try{
					row=rowIterator.next();
					}
					catch(Exception e)
					{
						break;
					}
					if(row==null)
					{
						break;
					}
					
					if(i!=0){
					Cell cell =row.getCell(2);
					cell.setCellValue("OD"+i);
					System.out.println("Set");
					}
					i++;
				}
				
			
				Name rangeName = workbook.getName("table1");
				rangeName.setRefersToFormula("Sheet1!$A$2:$C$10");
				
				System.out.println(rangeName);
				
				SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
				StringBuffer vFormatedDate=new StringBuffer("");
				simpleDateFormat.format(new Date(), vFormatedDate, new FieldPosition(0));
				
				StringBuffer fileDestination=new StringBuffer("D:\\Temp\\26 Apr 2019\\out\\TestTemplate_"+vFormatedDate+".xlsx");;
				
				file.close();
				File file2 = new File(fileDestination.toString());
				FileOutputStream outputStream = new FileOutputStream(file2);
				workbook_sx.write(outputStream);
				outputStream.close();
				workbook_sx.dispose();
				
				System.out.println("Done");
				
			}catch(Exception r)
			{
				r.printStackTrace();
			}
		}

}