jexcelapi 的使用

最新推荐文章于 2024-09-01 11:24:22 发布

iteye_5361

最新推荐文章于 2024-09-01 11:24:22 发布

阅读量214

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/iteye_5361/article/details/82329816

版权

Java 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

<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;
	}