testexcel.java

在java中实现的excel导出功能。这也是一个很好的例子。

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 TestExcel {
	
	private static final String EXCEL_DIR = "D:\\";
	private static final String EXCEL_FILENAME = "risyu.xls";
	private static final String EXCEL_SHEETTEMPLATE = "template";
	private static final String EXCEL_SHEETNAME = "履修一覧";
	private static final int POS_EXCEL_OFFSET = 1;
	private static final int POS_EXCEL_CNT = 0;
	
	public static void main(String[] args) throws IOException {
	    FileInputStream inputStream = null;
	    FileOutputStream outputStream = null;
	    
    	File excel = new File(EXCEL_DIR + EXCEL_FILENAME);
    	
    	inputStream = new FileInputStream(excel);
    	HSSFWorkbook wbkRisyu = new HSSFWorkbook(inputStream);
    	
    	// シートを削除する
//    	int intSheetCnt = wbkRisyu.getSheetIndex(EXCEL_SHEETNAME);
//    	if ( -1 != intSheetCnt )
//    		wbkRisyu.removeSheetAt(intSheetCnt);
    	
    	// シートをコピーする
    	HSSFSheet newSheet = wbkRisyu.cloneSheet(wbkRisyu.getSheetIndex(EXCEL_SHEETTEMPLATE));
//    	wbkRisyu.cloneSheet(0);
//    	HSSFSheet newSheet = wbkRisyu.getSheetAt(0);
    	// シートを削除する
    	int intSheetCnt = wbkRisyu.getSheetIndex(EXCEL_SHEETNAME);
    	if ( -1 != intSheetCnt )
    		wbkRisyu.removeSheetAt(intSheetCnt);
    	wbkRisyu.setSheetName(1, EXCEL_SHEETNAME);
    	
    	int intCnt = POS_EXCEL_OFFSET;
	    
		HSSFRow newRow = newSheet.createRow(intCnt);
		
		HSSFCell newCell00 = newRow.createCell(POS_EXCEL_CNT);  //新規「セル」を作成
		
		Random rand = new Random();
		int radMan = rand.nextInt(1000);
		newCell00.setCellValue(radMan);
		System.out.println("SuiJIShu==="+radMan);
		
		outputStream = new FileOutputStream(excel);
		wbkRisyu.write(outputStream);
		inputStream.close();
		outputStream.close();
		System.out.println("cheng gong");
	}
}