Example usage for org.apache.poi.xssf.streaming SXSSFWorkbook setSheetOrder

Introduction

In this page you can find the example usage for org.apache.poi.xssf.streaming SXSSFWorkbook setSheetOrder.

Prototype

@Override
public void setSheetOrder(String sheetname, int pos) 

Source Link

Document

Sets the order of appearance for a given sheet.

Usage

From source file:tools.xor.service.AggregateManager.java

License:Apache License

private void writeSheetMap(SXSSFWorkbook wb, Map<String, String> sheetMap) {
    SXSSFSheet sh = (SXSSFSheet) wb.createSheet(Constants.XOR.EXCEL_INDEX_SHEET);

    int rowNo = 0;
    for (Map.Entry<String, String> entry : sheetMap.entrySet()) {
        Row row = sh.createRow(rowNo++);
        Cell sheetNameCell = row.createCell(0);
        Cell propertyNameCell = row.createCell(1);
        sheetNameCell.setCellValue(entry.getValue());
        propertyNameCell.setCellValue(entry.getKey());
    }//w w  w  .j av a2s.com

    sh.autoSizeColumn(0);
    sh.autoSizeColumn(1);
    wb.setSheetOrder(Constants.XOR.EXCEL_INDEX_SHEET, 1);
}

---