Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook createSheet

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook createSheet

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. createSheet

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook createSheet.

Prototype

@Override
public XSSFSheet createSheet(String sheetname)

Source Link

Document

Create a new sheet for this Workbook and return the high level representation.

Usage

From source file:com.griffinslogistics.excel.CMRGenerator.java

public static void generateSingle(OutputStream outputStream, BookspackageCMRModel bookspackageCMRModel,
        Pulsiodetails pulsioDetails) {//from  ww w .  j a  v  a2s.  co m
    try {
        XSSFWorkbook workbook = new XSSFWorkbook();

        //Get first sheet from the workbook
        XSSFSheet sheet = workbook.createSheet(bookspackageCMRModel.getPackageNumber());
        setDefaultSheetStyles(sheet);

        Map<String, CellStyle> styles = createStyles(workbook);
        int currentRow = 2;
        Row headerRow = sheet.createRow(currentRow);

        generateHeaderRow(headerRow, styles, bookspackageCMRModel.getPackageNumber());
        currentRow = generateSenderAndDriver(sheet, styles, currentRow);
        currentRow = generatePoint2Till9(sheet, styles, currentRow, bookspackageCMRModel.getDeliveryAddress());

        double weight = bookspackageCMRModel.getTotalWeight();
        Long totalBoxesCount = bookspackageCMRModel.getTotalBoxesCount();
        currentRow = generatePoints10Till15(totalBoxesCount, weight, sheet, styles, currentRow);
        currentRow = generatePoint15Till19(sheet, styles, currentRow);
        currentRow = generatePoint20Till24(sheet, styles, currentRow, pulsioDetails);

        workbook.write(outputStream);

    } catch (FileNotFoundException ex) {
        Logger.getLogger(CMRGenerator.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(CMRGenerator.class.getName()).log(Level.SEVERE, null, ex);
    }
}

From source file:com.hp.autonomy.frontend.reports.powerpoint.PowerPointServiceImpl.java

License:MIT License

/**
 * Utility function to write the date graph data as a Excel workbook; required since PowerPoint charts actually
 *   embed an Excel file with corresponding data. If invalid, it'll open in OpenOffice fine, but PowerPoint will
 *   complain that the presentation is corrupted.
 * @param data the date graph data.//from   w w  w .j  av  a2 s.com
 * @return a new Excel workbook with specified data on a new sheet.
 */
private static XSSFWorkbook writeChart(final DategraphData data) {
    final XSSFWorkbook wb = new XSSFWorkbook();
    final XSSFSheet sheet = wb.createSheet("Sheet1");

    final CellStyle cellStyle = wb.createCellStyle();
    cellStyle.setDataFormat((short) 14);

    final List<DategraphData.Row> rows = data.getRows();
    final long[] timestamps = data.getTimestamps();

    final XSSFRow header = sheet.createRow(0);
    header.createCell(0).setCellValue("Timestamp");
    for (int ii = 0; ii < rows.size(); ++ii) {
        header.createCell(ii + 1).setCellValue(rows.get(ii).getLabel());
    }

    for (int rowIdx = 0; rowIdx < timestamps.length; ++rowIdx) {
        final XSSFRow row = sheet.createRow(rowIdx + 1);

        final XSSFCell cell = row.createCell(0);
        cell.setCellStyle(cellStyle);
        cell.setCellValue(new Date(timestamps[rowIdx] * 1000));

        for (int ii = 0; ii < rows.size(); ++ii) {
            row.createCell(ii + 1).setCellValue(rows.get(ii).getValues()[rowIdx]);
        }
    }

    return wb;
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimNotas(int idCurso) {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("Boletim Notas");
    NotaServer.getExcelBoletimNotas(wb, sheet, idCurso);
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimNotas_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimNotas(ArrayList<TableMultipleBoletimNotas> listTableMBD) {

    XSSFWorkbook wb = new XSSFWorkbook();
    for (int i = 0; i < listTableMBD.size(); i++) {
        TableMultipleBoletimNotas tableMBD = listTableMBD.get(i);
        String strTab = Integer.toString(i + 1) + ") ";
        strTab += tableMBD.getNomeCurso().substring(0, 3);
        XSSFSheet sheet = wb.createSheet(strTab);
        NotaServer.getExcelBoletimNotas(wb, sheet, tableMBD.getIdCurso());
    }/* w  w w.  j av a2 s .  c  o m*/
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimNotas_");

}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimPeriodo(int idCurso, int idPeriodo) {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("Boletim Periodo");
    NotaServer.gerarExcelBoletimPeriodo(wb, sheet, idCurso, idPeriodo);
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimPeriodo_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimPeriodo(ArrayList<TableMultipleBoletimPeriodo> listTableMBD) {

    XSSFWorkbook wb = new XSSFWorkbook();
    for (int i = 0; i < listTableMBD.size(); i++) {
        TableMultipleBoletimPeriodo tableMBD = listTableMBD.get(i);

        String strTab = Integer.toString(i + 1) + ") ";
        strTab += tableMBD.getNomeCurso().substring(0, 3) + "-";
        strTab += tableMBD.getNomePeriodo().substring(0, 3);
        XSSFSheet sheet = wb.createSheet(strTab);
        NotaServer.gerarExcelBoletimPeriodo(wb, sheet, tableMBD.getIdCurso(), tableMBD.getIdPeriodo());
    }/*from ww  w. ja v a  2s  .c  o m*/
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimPeriodo_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimAluno(int idCurso, int idAluno) {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("Boletim Anual Aluno");
    NotaServer.getExcelBoletimAluno(wb, sheet, idCurso, idAluno);
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimAnualAluno_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimAluno(ArrayList<TableMultipleBoletimAluno> listTableMBD) {
    XSSFWorkbook wb = new XSSFWorkbook();
    for (int i = 0; i < listTableMBD.size(); i++) {
        TableMultipleBoletimAluno tableMBD = listTableMBD.get(i);
        String strTab = Integer.toString(i + 1) + ") ";
        strTab += tableMBD.getNomeCurso().substring(0, 3) + "-";
        strTab += tableMBD.getNomeAluno().substring(0, 3);
        XSSFSheet sheet = wb.createSheet(strTab);
        NotaServer.getExcelBoletimAluno(wb, sheet, tableMBD.getIdCurso(), tableMBD.getIdAluno());
    }/* ww w.  j  av  a 2 s  .  c o  m*/
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimAnualAluno_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelBoletimAnual(int idCurso) {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("Boletim Anual");
    NotaServer.getExcelBoletimAnual(wb, sheet, idCurso);
    return ExcelFramework.getExcelAddress(wb, "GerarExcelBoletimAnual_");
}

From source file:com.jornada.server.service.GWTServiceNotaImpl.java

License:Open Source License

public String getExcelHistoricoAluno(int idCurso, int idAluno) {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("Historico");
    NotaServer.getExcelHistoricoAluno(wb, sheet, idCurso, idAluno);
    return ExcelFramework.getExcelAddress(wb, "GerarExcelHistoricoAluno_");
}