JXL操作Excel

jxl创建Excel:jxl只能操作Excel;需要jxl-2.4.2.jar
    /**
     * 创建Excel文件
     *
     * @param path：Excel存在路径绝对路径（D://test.xls）
     * @return
     */
    public boolean buildExcel(String path)
    {
        boolean flag = false;
        File fileWrite = new File(path);
        OutputStream fos = null;
        try
        {
            fos = new FileOutputStream(fileWrite);
            WritableWorkbook wwb = Workbook.createWorkbook(fos);
            // 创建3个页签数据
            for (int sheet = 1; sheet <= 3; sheet++)
            {
                String sheetName = "第" + sheet + "个页签";// 页签名
                WritableSheet ws = wwb.createSheet(sheetName, sheet - 1);
                int rowCount = 5;// 最大行数
                int colCount = 8;// 最大列数
                ws.addCell(new Label(0, 0, "XXXX报表", getFormat()));// 插入标题
                ws.mergeCells(0, 0, colCount - 1, 0);// 合并单元格，参数格式（0列，0行，结束列，0行)
                ws.addCell(new Label(0, 1, " "));
                // 填充表格
                for (int i = 0; i < rowCount; i++)
                {
                    for (int j = 0; j < colCount; j++)
                    {
                        String colValue = "abc.12";
                        // 假如为数字
                        if (DocumentTool.isNumber(colValue))
                        {
                            double dd = Double.valueOf(colValue);
                            jxl.write.Number number = new jxl.write.Number(j,i + 2, dd, getFormat());
                            ws.addCell(number);
                        }
                        else
                        {
                            ws.addCell(new Label(j, i + 2, colValue,getFormat()));// 填充表格,设置样式
                        }
                        ws.setColumnView(j, 100);// 设置每列的宽度
                    }
                }
                ws.mergeCells(0, 0, 3, 2);// 调整格式
            }
            wwb.write();
            wwb.close();
            fos.flush();
            fos.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
            return false;
        }
        finally
        {
            if (null != fos)
            {
                try
                {
                    fos.close();
                }
                catch (IOException e)
                {
                    e.printStackTrace();
                }
                finally
                {
                    fos = null;
                }
            }
        }
        return flag;
    }
    /**
     * @author dKF63467 设置excel表格格式
     * @return
     */
    public static WritableCellFormat getFormat()
    {
        WritableFont content = new WritableFont(WritableFont.createFont("宋体"),
                10, WritableFont.NO_BOLD, false);
        jxl.write.WritableCellFormat contentFormat = new jxl.write.WritableCellFormat(
                content);

        try
        {
            // 设置垂直栏目运营支撑费正文
            contentFormat.setVerticalAlignment(VerticalAlignment.CENTRE);// 垂直居中显示
            contentFormat.setAlignment(Alignment.CENTRE);// 水平居中显示
            contentFormat.setBorder(Border.ALL, BorderLineStyle.THIN);// 外框加粗
            contentFormat.setShrinkToFit(false);
            contentFormat.setWrap(true);// 设置自动换行
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        return contentFormat;
    }
这是我在项目中的积累，留下来下次碰到了可以直接使用