导出数据到Excel文件中

导出数据到Excel文件中:

	
    /**
     * 导出数据到Excel文件中
     * 下面的例子，设置了数字、日期的格式，还有字体，颜色等。
     * @throws Exception
     * @throws WriteException
     */
    public void test() throws Exception, WriteException{
    	
        // 创建指定名称的Excel
    	WritableWorkbook workbook = Workbook.createWorkbook(new File("d:/ExcelTest/output.xls"));
    	// 创建工作表
    	WritableSheet sheet = workbook.createSheet("TestCreateExcel", 1);

    	//一些临时变量，用于写到excel中
    	Label l=null;
    	jxl.write.Number n=null;
    	jxl.write.DateTime d=null;

    	//预定义的一些字体和格式，同一个Excel中最好不要有太多格式
    	WritableFont headerFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD,false,                    
    			UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLUE);
    	WritableCellFormat headerFormat = new WritableCellFormat(headerFont);

    	// 设置字体和格式
    	WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false,
    			UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
    	WritableCellFormat titleFormat = new WritableCellFormat(titleFont);

        // 设置字体和格式
    	WritableFont detFont = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false, 
    			UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
    	WritableCellFormat detFormat = new WritableCellFormat(detFont);

    	
    	//用于Number的格式
    	NumberFormat nf=new NumberFormat("0.00000");  
    	WritableCellFormat priceFormat = new WritableCellFormat(detFont, nf);

    	// 用于日期的
    	DateFormat df=new DateFormat("yyyy-MM-dd");
    	WritableCellFormat dateFormat = new WritableCellFormat(detFont, df);

    	//剩下的事情，就是用上面的内容和格式创建一些单元格，再加到sheet中
    	l=new Label(0, 0, "用于测试的Excel文件", headerFormat);
    	sheet.addCell(l);
    	//add Title
    	int column=0;
    	l=new Label(column++, 2, "标题", titleFormat);
    	sheet.addCell(l);
    	l=new Label(column++, 2, "日期", titleFormat);
    	sheet.addCell(l);
    	l=new Label(column++, 2, "货币", titleFormat);
    	sheet.addCell(l);
    	l=new Label(column++, 2, "价格", titleFormat);
    	sheet.addCell(l);

    	//add detail
    	int i=0;
    	column=0;
    	l=new Label(column++, i+3, "标题 "+i, detFormat);
    	sheet.addCell(l);
    	d=new DateTime(column++, i+3, new Date(), dateFormat);
    	sheet.addCell(d);
    	l=new Label(column++, i+3, "CNY", detFormat);
    	sheet.addCell(l);
    	n=new Number(column++, i+3, 5.678, priceFormat);
    	sheet.addCell(n);

    	i++;
    	column=0;
    	l=new Label(column++, i+3, "标题 "+i, detFormat);
    	sheet.addCell(l);
    	d=new DateTime(column++, i+3, new Date(),dateFormat);
    	sheet.addCell(d);
    	l=new Label(column++, i+3, "SGD", detFormat);
    	sheet.addCell(l);
    	n=new Number(column++, i+3, 98832,priceFormat);
    	sheet.addCell(n);

    	//设置列的宽度
    	column=0;
    	sheet.setColumnView(column++, 20);
    	sheet.setColumnView(column++, 20);
    	sheet.setColumnView(column++, 10);
    	sheet.setColumnView(column++, 20);

    	workbook.write();
    	workbook.close();
    }