package src.com.jp.or.cheng.excel;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Random;

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;

public class TestE {

	/**
	 * @param args
	 * @throws IOException 
	 */
	public static void main(String[] args) throws IOException {
		// TODO Auto-generated method stub
		FileInputStream fis = null;
		FileOutputStream fos = null;
		
		File excel = new File("D:\\testE.xls");
		
		fis = new FileInputStream(excel);
		HSSFWorkbook hwb = new HSSFWorkbook(fis);
		
//		int intCnt = hwb.getSheetIndex("test");
//		if(-1 != intCnt){
//			hwb.removeSheetAt(intCnt);
//		}
		
//		int intC = hwb.getSheetIndex("template");
//		System.out.println("template ===" + intC);
//		HSSFSheet newSheet = hwb.cloneSheet(intC +1);
//		hwb.cloneSheet(0);
		HSSFSheet newSheet = hwb.cloneSheet(hwb.getSheetIndex("template"));
//		hwb.setSheetName(1, "test");
//		HSSFSheet newSheet = hwb.getSheetAt(0);
//		hwb.cloneSheet(0);
		int intCnt = hwb.getSheetIndex("test");
		if(-1 != intCnt){
			hwb.removeSheetAt(intCnt);
		}
		hwb.setSheetName(1, "test");
		
    	HSSFRow newRow = newSheet.createRow(1);
		
		HSSFCell newCell00 = newRow.createCell(0);  //新規「セル」を作成
		
		Random rand = new Random();
		int radMan = rand.nextInt(1000);
		newCell00.setCellValue(radMan);
		System.out.println("SuiJIShu==="+radMan);
		
		fos = new FileOutputStream(excel);
		hwb.write(fos);
		fis.close();
		fos.close();
		System.out.println("cheng gong");
	}
}