Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook createCellStyle

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook createCellStyle

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. createCellStyle

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook createCellStyle.

Prototype

@Override
public HSSFCellStyle createCellStyle()

Source Link

Document

Create a new Cell style and add it to the workbook's style table.

Usage

From source file:br.sp.telesul.service.ExportServiceImpl.java

public void writeExcelIdiomas(String templateHead, String[] columns, HSSFWorkbook workbook) {
    try {//  w  ww .j  ava2  s. c o  m
        List<Funcionario> funcionarios = funcionarioService.search();

        HSSFSheet sheet = workbook.createSheet(templateHead);

        Row rowHeading = sheet.createRow(0);
        for (int i = 0; i < columns.length; i++) {
            rowHeading.createCell(i).setCellValue(columns[i]);
        }
        //Estilizar o Cabealho - Stylesheet the heading
        for (int i = 0; i < columns.length; i++) {
            CellStyle stylerowHeading = workbook.createCellStyle();
            Font font = workbook.createFont();
            font.setBold(true);
            font.setFontName(HSSFFont.FONT_ARIAL);
            font.setFontHeightInPoints((short) 11);
            font.setColor(HSSFColor.WHITE.index);
            stylerowHeading.setFont(font);
            stylerowHeading.setVerticalAlignment(CellStyle.ALIGN_CENTER);
            stylerowHeading.setFillForegroundColor(HSSFColor.ROYAL_BLUE.index);
            stylerowHeading.setFillPattern(CellStyle.SOLID_FOREGROUND);
            rowHeading.getCell(i).setCellStyle(stylerowHeading);
        }
        //Preencher linhas
        int r = 1;
        for (Funcionario f : funcionarios) {

            if (!f.getIdiomas().isEmpty()) {

                for (Idioma idm : f.getIdiomas()) {
                    try {
                        if (idm.getNivel() != null || idm.getNome() != null) {
                            Row row = sheet.createRow(r);
                            Cell Nome = row.createCell(0);
                            Nome.setCellValue(f.getNome());

                            Cell language = row.createCell(1);
                            language.setCellValue(idm.getNome().toString());

                            Cell nivel = row.createCell(2);
                            nivel.setCellValue(idm.getNivel().toString());
                            r++;
                        }
                    } catch (NullPointerException ne) {
                        System.out.println("Error " + ne);
                        break;
                    }

                }

            }

        }

        for (int i = 0; i < columns.length; i++) {
            sheet.autoSizeColumn(i);
        }

    } catch (Exception e) {
        System.out.println("Error" + e);
    }
}

From source file:br.sp.telesul.service.ExportServiceImpl.java

public void writeExcelSingle(Long id, HSSFWorkbook workbook) {
    String[] columns = { "Nome", "Cargo", "Data de Admissao", "?rea", "Gestor", "Email", "Telefone",
            "Celular" };
    String[] colFormacao = { "Formao", "Curso", "Instituio", "Cpia de Certificao" };
    String[] colIdioma = { "Idioma", "Nvel" };
    String[] colCertificacao = { "Certificadora", "Exame", "Cdigo", "Data de Exame", "Data de Validade",
            "Cpia de Certificado" };
    try {/*from   ww  w  .j  a v  a  2 s  .  c om*/
        Funcionario funcionario = this.funcionarioService.searchById(id);

        HSSFSheet sheet = workbook.createSheet("Funcionrio");

        Row rowHeading = sheet.createRow(0);
        for (int i = 0; i < columns.length; i++) {
            rowHeading.createCell(i).setCellValue(columns[i]);
        }
        stylizeHeader(rowHeading, workbook, columns);

        int r = 1;

        Row row = sheet.createRow(r);

        Cell Nome = row.createCell(0);
        Nome.setCellValue(funcionario.getNome());
        Cell cargo = row.createCell(1);
        cargo.setCellValue(funcionario.getCargo());

        Cell dtAdmissao = row.createCell(2);
        dtAdmissao.setCellValue(funcionario.getDtAdmissao());

        CellStyle styleDate = workbook.createCellStyle();
        HSSFDataFormat dfAdmissao = workbook.createDataFormat();
        styleDate.setDataFormat(dfAdmissao.getFormat("dd/mm/yyyy"));
        dtAdmissao.setCellStyle(styleDate);

        Cell area = row.createCell(3);
        area.setCellValue(funcionario.getArea());

        Cell gestor = row.createCell(4);
        gestor.setCellValue(funcionario.getGestor());

        try {
            Cell email = row.createCell(5);
            email.setCellValue(funcionario.getEmail());

        } catch (NullPointerException ne) {

        }
        try {
            Cell telefone = row.createCell(6);
            telefone.setCellValue(funcionario.getTelefone());

        } catch (NullPointerException ne) {

        }
        try {
            Cell celular = row.createCell(7);
            celular.setCellValue(funcionario.getCelular());
        } catch (NullPointerException ne) {

        }

        int auxRow = 12;
        for (Formacao form : funcionario.getFormacoes()) {
            if (!form.getCurso().isEmpty() || !form.getNivel().isEmpty() || !form.getInstituicao().isEmpty()) {
                int headerFormacao = 11;
                Row rowHeadingForm = sheet.createRow(headerFormacao);
                for (int i = 0; i < colFormacao.length; i++) {
                    rowHeadingForm.createCell(i).setCellValue(colFormacao[i]);
                }
                stylizeHeader(rowHeadingForm, workbook, colFormacao);
                int rowFormacao = 12;
                Row rowFormacaoDatas = sheet.createRow(rowFormacao);
                Cell formacao = rowFormacaoDatas.createCell(0);
                Cell curso = rowFormacaoDatas.createCell(1);
                Cell instituicao = rowFormacaoDatas.createCell(2);
                Cell copy = rowFormacaoDatas.createCell(3);
                for (Formacao f : funcionario.getFormacoes()) {
                    try {
                        formacao.setCellValue(f.getNivel());
                    } catch (NullPointerException e) {

                    }
                    try {
                        curso.setCellValue(f.getCurso());
                    } catch (NullPointerException e) {

                    }
                    try {
                        instituicao.setCellValue(f.getInstituicao());
                    } catch (NullPointerException e) {

                    }
                    try {
                        copy.setCellValue(f.getCopiaCertificado());
                    } catch (NullPointerException e) {

                    }

                    rowFormacao++;
                    auxRow = rowFormacao;
                }
                autoSizeColum(sheet, colFormacao);
            }
        }
        for (Idioma i : funcionario.getIdiomas()) {
            try {
                if (!i.getNome().toString().isEmpty() && !i.getNivel().toString().isEmpty()) {
                    int headerIdiomas = auxRow + 9;
                    Row rowHeadingIdioma = sheet.createRow(headerIdiomas);
                    for (int j = 0; j < colIdioma.length; j++) {
                        rowHeadingIdioma.createCell(j).setCellValue(colIdioma[j]);
                    }
                    stylizeHeader(rowHeadingIdioma, workbook, colIdioma);
                    int rowIdioma = headerIdiomas + 1;
                    Row rowIdiomasDatas = sheet.createRow(rowIdioma);
                    Cell nivelIdm = rowIdiomasDatas.createCell(0);
                    Cell language = rowIdiomasDatas.createCell(1);
                    for (Idioma j : funcionario.getIdiomas()) {
                        nivelIdm.setCellValue(j.getNivel().toString());
                        language.setCellValue(j.getNome().toString());
                        rowIdioma++;
                        auxRow = rowIdioma;
                    }
                    autoSizeColum(sheet, colIdioma);
                }
            } catch (NullPointerException ne) {
                logger.error("Idiomas" + ne);
                break;
            }

        }

        if (funcionario.getCertificacoes().size() > 0) {
            int headerCertificacao = auxRow + 9;
            Row rowHeadingCert = sheet.createRow(headerCertificacao);
            for (int j = 0; j < colCertificacao.length; j++) {
                rowHeadingCert.createCell(j).setCellValue(colCertificacao[j]);
            }
            stylizeHeader(rowHeadingCert, workbook, colCertificacao);
            int rowCert = headerCertificacao + 1;

            for (Certificacao c : funcionario.getCertificacoes()) {
                Row rowCertDatas = sheet.createRow(rowCert);
                Cell certificadora = rowCertDatas.createCell(0);
                Cell exame = rowCertDatas.createCell(1);
                Cell codigo = rowCertDatas.createCell(2);
                Cell dtExame = rowCertDatas.createCell(3);
                dtExame.setCellStyle(styleDate);
                Cell dtValidade = rowCertDatas.createCell(4);
                dtValidade.setCellStyle(styleDate);
                Cell copia = rowCertDatas.createCell(5);
                try {
                    certificadora.setCellValue(c.getEmpresa());
                } catch (NullPointerException e) {

                }
                try {
                    exame.setCellValue(c.getNome());
                } catch (NullPointerException e) {

                }
                try {
                    codigo.setCellValue(c.getCodigo());
                } catch (NullPointerException e) {

                }
                try {
                    dtExame.setCellValue(c.getDtExame());
                } catch (NullPointerException e) {

                }
                try {
                    dtValidade.setCellValue(c.getDtValidade());
                } catch (NullPointerException e) {

                }
                try {
                    copia.setCellValue(c.getCopia());
                } catch (NullPointerException e) {

                }

                rowCert++;
            }
            autoSizeColum(sheet, colCertificacao);
        }

        //r++;
    } catch (Exception e) {
        logger.error("Error Writing Single Report: " + e);
        System.out.println("rror Writing Single Report: " + e);
    }
}

From source file:br.sp.telesul.service.ExportServiceImpl.java

public void stylizeHeader(Row rowHeading, HSSFWorkbook workbook, String[] columns) {
    for (int i = 0; i < columns.length; i++) {
        CellStyle stylerowHeading = workbook.createCellStyle();
        Font font = workbook.createFont();
        font.setBold(true);//from   w w  w. ja v a  2 s .  c o m
        font.setFontName(HSSFFont.FONT_ARIAL);
        font.setFontHeightInPoints((short) 11);
        font.setColor(HSSFColor.WHITE.index);
        stylerowHeading.setFont(font);
        stylerowHeading.setVerticalAlignment(CellStyle.ALIGN_CENTER);
        stylerowHeading.setFillForegroundColor(HSSFColor.ROYAL_BLUE.index);
        stylerowHeading.setFillPattern(CellStyle.SOLID_FOREGROUND);
        rowHeading.getCell(i).setCellStyle(stylerowHeading);
    }
}

From source file:br.ufpa.psi.comportamente.labgame.mbeans.RelatoriosMB.java

License:Open Source License

public StreamedContent geraRelatorioJogadasExperimento()
        throws ParsePropertyException, IOException, InvalidFormatException {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Relatrio das Jogadas");

    sheet.setColumnWidth(sheet.getFirstRowNum(), (14 * 256) + 200);
    sheet.setColumnWidth(1, (14 * 256) + 200);
    sheet.setColumnWidth(4, (17 * 256) + 200);
    sheet.setColumnWidth(5, (16 * 256) + 200);

    HSSFCellStyle cs1 = workbook.createCellStyle();
    cs1.setDataFormat(HSSFDataFormat.getBuiltinFormat("d-mmm-yy"));

    HSSFCellStyle cs2 = workbook.createCellStyle();
    cs2.setDataFormat(HSSFDataFormat.getBuiltinFormat("h:mm:ss"));

    JogadaDAO jogadaDAO = new JogadaDAO();
    jogadaDAO.beginTransaction();//ww  w .  ja  v  a 2 s . c om
    List<Jogada> jogadas = jogadaDAO.encontrarPorExperimento(experimentoSelecionado.getId());

    int countRow = 0;
    Row row1 = sheet.createRow(countRow++);
    Cell cell = row1.createCell(0);
    cell.setCellValue("Experimento: " + experimentoSelecionado.getNome());

    Row row = sheet.createRow(countRow++);

    row.createCell(0).setCellValue("Data da Jogada");
    row.createCell(1).setCellValue("Hora da Jogada");
    row.createCell(2).setCellValue("Coluna");
    row.createCell(3).setCellValue("Linha");
    row.createCell(4).setCellValue("Pontuacao Individual");
    row.createCell(5).setCellValue("Pontuacao Coletiva");
    row.createCell(6).setCellValue("Participante");
    row.createCell(7).setCellValue("Condio");

    for (Jogada jogada : jogadas) {

        Row nrow = sheet.createRow(countRow++);

        //Data
        Cell ncell0 = nrow.createCell(0);
        ncell0.setCellValue(jogada.getMomento());
        ncell0.setCellStyle(cs1);

        //Hora
        Cell ncell1 = nrow.createCell(1);
        ncell1.setCellValue(jogada.getMomento());
        ncell1.setCellStyle(cs2);

        //Coluna
        Cell ncell2 = nrow.createCell(2);
        ncell2.setCellValue(jogada.getColunaSelecionada());

        //Linha
        Cell ncell3 = nrow.createCell(3);
        ncell3.setCellValue(jogada.getLinhaSelecionada());

        //Pontuao Individual
        Cell ncell4 = nrow.createCell(4);
        ncell4.setCellValue(jogada.getPontuacaoIndividual());

        //Pontuao Coletiva
        Cell ncell5 = nrow.createCell(5);
        ncell5.setCellValue(jogada.getPontuacaoCultural());

        //Jogador
        Cell ncell6 = nrow.createCell(6);
        ncell6.setCellValue(jogada.getJogador().getNome());

        //Id da Condio
        Cell ncell7 = nrow.createCell(7);
        ncell7.setCellValue(jogada.getIdCondicao());

    }

    jogadaDAO.stopOperation(false);

    byte[] bytes;
    try (ByteArrayOutputStream out = new ByteArrayOutputStream()) {
        workbook.write(out);
        bytes = out.toByteArray();
    }

    InputStream ioStream = new ByteArrayInputStream(bytes);
    file = new DefaultStreamedContent(ioStream, "application/vnd.ms-excel", "Relatrio_Jogadas.xls");
    return file;
}

From source file:bs.proveedores.web.informe.CuentaCorrienteProveedorBean.java

public void postProcessXLS(Object document) {

    HSSFWorkbook wb = (HSSFWorkbook) document;
    HSSFSheet sheet = wb.getSheetAt(0);/*from  w w  w . ja va2s.com*/
    HSSFRow header = sheet.getRow(0);

    HSSFCellStyle cellStyle = wb.createCellStyle();
    cellStyle.setFillForegroundColor(HSSFColor.ORANGE.index);
    cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

    for (int i = 0; i < header.getPhysicalNumberOfCells(); i++) {
        HSSFCell cell = header.getCell(i);
        cell.setCellStyle(cellStyle);
    }
}

From source file:ch.astina.hesperid.util.jasper.JasperExcelStreamResponse.java

License:Apache License

@Override
public void exportReportToStream(JasperPrint jasperPrint, OutputStream outputStream) throws Exception {
    JRXlsExporter exporter = new JRXlsExporter();
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, baos);
    exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
            this.removeEmptySpaceBetweenRows);
    exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS,
            this.removeEmptySpaceBetweenColumns);
    exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, this.printWhitePageBackground);
    exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, this.fixFontSize);
    exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, this.ignoreGraphics);
    exporter.exportReport();//from w  ww . j  a  v a2  s. co  m

    HSSFWorkbook workbook = new HSSFWorkbook(new ByteArrayInputStream(baos.toByteArray()));
    workbook.getSheetAt(0).setAutobreaks(true);
    workbook.getSheetAt(0).getPrintSetup().setFitHeight((short) jasperPrint.getPages().size());
    workbook.getSheetAt(0).getPrintSetup().setFitWidth((short) 1);

    SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yyyy");

    HSSFCellStyle cellStyle = workbook.createCellStyle();
    cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));

    for (Integer x = 0; x < workbook.getSheetAt(0).getPhysicalNumberOfRows(); x++) {
        HSSFRow row = workbook.getSheetAt(0).getRow(x);

        Iterator<Cell> ci = row.cellIterator();

        Cell c = null;
        Date d = null;

        while (ci.hasNext()) {
            c = ci.next();
            try {
                d = sdf.parse(c.getStringCellValue().trim());
                c.setCellValue(d);
                c.setCellStyle(cellStyle);
            } catch (Exception e) {
            }
        }
    }

    workbook.write(outputStream);
}

From source file:cn.edu.henu.rjxy.lms.controller.Acdemic.java

@RequestMapping("daochuxuesheng")
public void daochuxuesheng(HttpServletRequest request, HttpServletResponse response) throws IOException {
    HttpSession session = request.getSession();
    session.setAttribute("state", null);
    // ????  /* w  w w. j  ava  2 s . c  o  m*/
    response.setContentType("application/vnd.ms-excel");
    String codedFileName;
    codedFileName = "??";
    OutputStream fOut = null;
    try {
        // ????  
        codedFileName = java.net.URLEncoder.encode("", "UTF-8");
        response.setHeader("content-disposition", "attachment;filename=" + "student_messsage" + ".xls");
        HSSFWorkbook wb = new HSSFWorkbook();
        // webbooksheet,Excelsheet  
        HSSFSheet sheet = wb.createSheet("");
        // sheet0,??poiExcel?short  
        HSSFRow row = sheet.createRow((int) 0);
        // ?   
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ? 
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 1);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 2);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 3);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 4);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 5);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 6);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 7);
        cell.setCellValue("qq");
        cell.setCellStyle(style);

        List allstudent = StudentDao.getAllStudent();

        for (int i = 0; i < allstudent.size(); i++) {
            StudentWithoutPwd tmp = (StudentWithoutPwd) allstudent.get(i);
            row = sheet.createRow((int) i + 1);
            row.createCell((short) 0).setCellValue(tmp.getStudentSn());
            row.createCell((short) 1).setCellValue(tmp.getStudentName());
            row.createCell((short) 2).setCellValue(tmp.getStudentIdcard());
            row.createCell((short) 3).setCellValue(tmp.getStudentGrade());
            row.createCell((short) 4).setCellValue((tmp.isStudentSex()) ? ("") : (""));
            row.createCell((short) 5).setCellValue(tmp.getStudentCollege());
            row.createCell((short) 6).setCellValue(tmp.getStudentTel());
            row.createCell((short) 7).setCellValue(tmp.getStudentQq());

        }

        fOut = response.getOutputStream();
        wb.write(fOut);
    } catch (UnsupportedEncodingException e1) {
    } catch (Exception e) {
    } finally {
        fOut.flush();
        fOut.close();
        session.setAttribute("state", "open");
    }
    System.out.println("?...");

}

From source file:cn.edu.henu.rjxy.lms.controller.Acdemic.java

@RequestMapping("daochualltoxls")
public void exportExcel(HttpServletRequest request, HttpServletResponse response) throws IOException {
    HttpSession session = request.getSession();
    System.out.println("1...");
    session.setAttribute("state", null);
    // ????  /*from  www .j  a  v a 2  s  .c  om*/
    response.setContentType("application/vnd.ms-excel");
    String codedFileName;
    codedFileName = "??";
    OutputStream fOut = null;
    try {
        // ????  
        codedFileName = java.net.URLEncoder.encode("", "UTF-8");
        response.setHeader("content-disposition", "attachment;filename=" + "teacher_messsage" + ".xls");
        HSSFWorkbook wb = new HSSFWorkbook();
        // webbooksheet,Excelsheet  
        HSSFSheet sheet = wb.createSheet("");
        // sheet0,??poiExcel?short  
        HSSFRow row = sheet.createRow((int) 0);
        // ?   
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ? 
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 1);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 2);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 3);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 4);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 5);
        cell.setCellValue("qq");
        cell.setCellStyle(style);
        cell = row.createCell((short) 6);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 7);
        cell.setCellValue("");
        cell.setCellStyle(style);

        List allteacher = TeacherDao.getAllTeacher();

        for (int i = 0; i < allteacher.size(); i++) {
            TempTeacherWithoutPwd tmp = (TempTeacherWithoutPwd) allteacher.get(i);
            row = sheet.createRow((int) i + 1);
            row.createCell((short) 0).setCellValue(tmp.getTeacherSn());
            row.createCell((short) 1).setCellValue(tmp.getTeacherName());
            row.createCell((short) 2).setCellValue(tmp.getTeacherIdcard());
            row.createCell((short) 3).setCellValue(tmp.getTeacherPosition());
            row.createCell((short) 4).setCellValue(tmp.getTeacherCollege());
            row.createCell((short) 5).setCellValue(tmp.getTeacherQq());
            row.createCell((short) 6).setCellValue(tmp.getTeacherTel());
            row.createCell((short) 7).setCellValue((tmp.getTeacherSex()) ? ("") : (""));

        }

        fOut = response.getOutputStream();
        wb.write(fOut);
    } catch (UnsupportedEncodingException e1) {
    } catch (Exception e) {
    } finally {
        fOut.flush();
        fOut.close();
        session.setAttribute("state", "open");
    }
    System.out.println("?...");
}

From source file:cn.edu.henu.rjxy.lms.controller.DeanController.java

@RequestMapping("dean/daochuxuesheng")
public void daochuxuesheng(HttpServletRequest request, HttpServletResponse response) throws IOException {
    HttpSession session = request.getSession();
    session.setAttribute("state", null);
    // ????  //from  w  w w . j a va 2  s.  co m
    response.setContentType("application/vnd.ms-excel");
    String codedFileName;
    codedFileName = "??";
    OutputStream fOut = null;
    try {
        // ????  
        codedFileName = java.net.URLEncoder.encode("", "UTF-8");
        response.setHeader("content-disposition", "attachment;filename=" + "student_messsage" + ".xls");
        HSSFWorkbook wb = new HSSFWorkbook();
        // webbooksheet,Excelsheet  
        HSSFSheet sheet = wb.createSheet("");
        // sheet0,??poiExcel?short  
        HSSFRow row = sheet.createRow((int) 0);
        // ?   
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ? 
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 1);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 2);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 3);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 4);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 5);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 6);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 7);
        cell.setCellValue("qq");
        cell.setCellStyle(style);

        List allstudent = StudentDao.getAllStudent();

        for (int i = 0; i < allstudent.size(); i++) {
            StudentWithoutPwd tmp = (StudentWithoutPwd) allstudent.get(i);
            row = sheet.createRow((int) i + 1);
            row.createCell((short) 0).setCellValue(tmp.getStudentSn());
            row.createCell((short) 1).setCellValue(tmp.getStudentName());
            row.createCell((short) 2).setCellValue(tmp.getStudentIdcard());
            row.createCell((short) 3).setCellValue(tmp.getStudentGrade());
            row.createCell((short) 4).setCellValue((tmp.isStudentSex()) ? ("") : (""));
            row.createCell((short) 5).setCellValue(tmp.getStudentCollege());
            row.createCell((short) 6).setCellValue(tmp.getStudentTel());
            row.createCell((short) 7).setCellValue(tmp.getStudentQq());

        }

        fOut = response.getOutputStream();
        wb.write(fOut);
    } catch (UnsupportedEncodingException e1) {
    } catch (Exception e) {
    } finally {
        fOut.flush();
        fOut.close();
        session.setAttribute("state", "open");
    }
    System.out.println("?...");

}

From source file:cn.edu.henu.rjxy.lms.controller.DeanController.java

@RequestMapping("dean/daochualltoxls")
public void exportExcel(HttpServletRequest request, HttpServletResponse response) throws IOException {
    HttpSession session = request.getSession();
    System.out.println("1...");
    session.setAttribute("state", null);
    // ????  /* w  w w  .  j a va2 s  . co m*/
    response.setContentType("application/vnd.ms-excel");
    String codedFileName;
    codedFileName = "??";
    OutputStream fOut = null;
    try {
        // ????  
        codedFileName = java.net.URLEncoder.encode("", "UTF-8");
        response.setHeader("content-disposition", "attachment;filename=" + "teacher_messsage" + ".xls");
        HSSFWorkbook wb = new HSSFWorkbook();
        // webbooksheet,Excelsheet  
        HSSFSheet sheet = wb.createSheet("");
        // sheet0,??poiExcel?short  
        HSSFRow row = sheet.createRow((int) 0);
        // ?   
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ? 
        HSSFCell cell = row.createCell((short) 0);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 1);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 2);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell((short) 3);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 4);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell((short) 5);
        cell.setCellValue("qq");
        cell.setCellStyle(style);
        cell = row.createCell((short) 6);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell((short) 7);
        cell.setCellValue("");
        cell.setCellStyle(style);

        List allteacher = TeacherDao.getAllTeacher();

        for (int i = 0; i < allteacher.size(); i++) {
            TempTeacherWithoutPwd tmp = (TempTeacherWithoutPwd) allteacher.get(i);
            row = sheet.createRow((int) i + 1);
            row.createCell((short) 0).setCellValue(tmp.getTeacherSn());
            row.createCell((short) 1).setCellValue(tmp.getTeacherName());
            row.createCell((short) 2).setCellValue(tmp.getTeacherIdcard());
            row.createCell((short) 3).setCellValue(tmp.getTeacherPosition());
            row.createCell((short) 4).setCellValue(tmp.getTeacherCollege());
            row.createCell((short) 5).setCellValue(tmp.getTeacherQq());
            row.createCell((short) 6).setCellValue(tmp.getTeacherTel());
            row.createCell((short) 7).setCellValue((tmp.getTeacherSex()) ? ("") : (""));

        }

        fOut = response.getOutputStream();
        wb.write(fOut);
    } catch (UnsupportedEncodingException e1) {
    } catch (Exception e) {
    } finally {
        fOut.flush();
        fOut.close();
        session.setAttribute("state", "open");
    }
    System.out.println("?...");
}