jexcelapi 的使用

<result name="dayExcel" type="stream">
	<param name="contentType">application/vnd.ms-excel</param>
	<param name="contentDisposition">filename="export.xls"</param>
	<param name="bufferSize">1024</param>
</result>

 

	InputStream is;

	public String execute() {

		Label label;
		WritableWorkbook workbook;
		ByteArrayOutputStream os = new ByteArrayOutputStream();
		try {
			workbook = Workbook.createWorkbook(os);
			WritableSheet sheet = workbook.createSheet("Sheet1", 0);
			label = new jxl.write.Label(0, 0, "Time/Hour");
			sheet.addCell(label);
			for (int i = 0; i < 24; i++) {
				if (i < 10) {
					label = new jxl.write.Label(0, i+1, "0" + i);
					sheet.addCell(label);
				} else {
					label = new jxl.write.Label(0, i+1, String.valueOf(i));
					sheet.addCell(label);
				}
			}

			workbook.write();
			workbook.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		is = new ByteArrayInputStream(os.toByteArray());
		return "excel";

	}

	public InputStream getIs() {
		return is;
	}

	public void setIs(InputStream is) {
		this.is = is;
	}

	public InputStream getInputStream() throws Exception {
		return is;
	}