Java写Excel文件

Java写Excel文件也可以用jxl.jar包。

下面是一个例子：

public void excelprintResult()				// 打印输出结果到excel中
{
	File file0 = new File(ctime0 + ".xls");	// 文件名
	try {
		WritableWorkbook wb0 = Workbook.createWorkbook(file0);	// 创建工作簿
		WritableSheet sheet0 = wb0.createSheet("sheet0",0);		// 创建表页
		int i = 0, len0 = firstSet.size();
		String cid, cname, cctime, cbuil, croom;
		int capacity;
		for (i=0; i<len0; i++)
		{
			CourseLoad cl = firstSet.get(i);
			cid = cl.id;
			cname = cl.getName();
			cctime = cl.getCTime();
			capacity = cl.getCapacity();
			cbuil = cl.getBuildingName();
			croom = cl.getRoomName();
			Label label = new Label(0,i,cid);//标准的一条数据:(column,row,(String)entry)
			sheet0.addCell(label);
			label = new Label(1,i,cname);
			sheet0.addCell(label);
			label = new Label(2,i,cctime);
			sheet0.addCell(label);
			label = new Label(3,i,String.valueOf(capacity));
			sheet0.addCell(label);
			label = new Label(4,i,cbuil);
			sheet0.addCell(label);
			label = new Label(5,i,croom);
			sheet0.addCell(label);
		}
		wb0.write();		// wb.close()之前一定要加wb.write()
		wb0.close();
	}
	catch (WriteException e)
	{
		e.printStackTrace();
	}
	catch (IOException e)
	{
		e.printStackTrace();
	}
}