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

Introduction

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

Prototype

@Override
public String getSheetName(int sheet) 

Source Link

Document

Set the sheet name

Usage

From source file:egovframework.rte.fdl.excel.EgovExcelSXSSFServiceTest.java

License:Apache License

/**
 * [Flow #-1]  ? ? :   ?? ?/*from w  w w . jav  a2  s.  c  o m*/
 */
@Test
public void testWriteExcelFile() throws Exception {

    try {
        log.debug("testWriteExcelFile start....");

        String sheetName1 = "first sheet";
        String sheetName2 = "second sheet";
        StringBuffer sb = new StringBuffer();
        sb.append(fileLocation).append("/").append("testWriteExcelFile.xlsx");

        // delete file
        if (EgovFileUtil.isExistsFile(sb.toString())) {
            EgovFileUtil.delete(new File(sb.toString()));
            log.debug("Delete file...." + sb.toString());
        }

        SXSSFWorkbook wb = new SXSSFWorkbook();

        wb.createSheet(sheetName1);
        wb.createSheet(sheetName2);
        wb.createSheet();

        //  ? ?
        SXSSFWorkbook tmp = excelService.createSXSSFWorkbook(wb, sb.toString());

        // ?  ?
        assertTrue(EgovFileUtil.isExistsFile(sb.toString()));

        // ? Sheet ? ?
        assertEquals(sheetName1, tmp.getSheetName(0));
        assertEquals(sheetName2, tmp.getSheetName(1));

    } catch (Exception e) {
        log.error(e.toString());
        throw new Exception(e);
    } finally {
        log.debug("testWriteExcelFile end....");
    }
}

---