jexcelの使い方(覚書)

		ServletContext application = getServlet().getServletContext();

		Workbook workbook = null;
		WorkbookSettings settings = new WorkbookSettings();
		// System.gc()「ガベージコレクション」の実行をOFFに設定
		settings.setGCDisabled(true);

		// エクセルシートの参照
		workbook = Workbook.getWorkbook((new File(application
				.getRealPath("/WEB-INF/template/template.xls"))), settings);

		String filename = MyEncoder.encode("jexcel.xls", "UTF-8");
		response.setHeader("Content-Disposition", "attachment;filename="
				+ filename);
		response.setContentType("application/vnd.ms-excel");

		// エクセルファイルの呼び出し
		WritableWorkbook writableWorkbook = Workbook.createWorkbook(response
				.getOutputStream(), workbook, settings);

		WritableSheet sheet = writableWorkbook.getSheet(1);

		// セルへの書き出し
		int data[] = { 111, 222, 333, 444, 555 };
		for (int i = 1; i < 6; i++) {
			jxl.write.Number number = new jxl.write.Number(i, 2, data[i - 1]);
			sheet.addCell(number);
		}

		writableWorkbook.write();
		writableWorkbook.close();