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

Introduction

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

Prototype

public XSSFWorkbook()

Source Link

Document

Create a new SpreadsheetML workbook.

Usage

From source file:cherry.goods.excel.ExcelFactory.java

License:Apache License

/**
 * Excel (.xlsx) ???<br />/*  ww w.j  ava 2 s  . co m*/
 * 
 * @param sheetname ??????
 * @return ???Excel
 */
public static Workbook createBlankXlsx(String sheetname) {
    return createSheet(new XSSFWorkbook(), sheetname);
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testGetNumberOfSheets() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from   w ww  . j a v  a  2 s. co  m*/
        workbook.createSheet("CREATED 0");
        workbook.createSheet("CREATED 1");
        workbook.createSheet("CREATED 2");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {
            assertEquals(3, reader.getNumberOfSheets());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testGetSheetName() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*  w  w  w . j  a v  a  2 s  .c  o m*/
        workbook.createSheet("CREATED 0");
        workbook.createSheet("CREATED 1");
        workbook.createSheet("CREATED 2");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {
            assertEquals("CREATED 0", reader.getSheetName(0));
            assertEquals("CREATED 1", reader.getSheetName(1));
            assertEquals("CREATED 2", reader.getSheetName(2));
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testSetCurrentSheet() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from  w ww  .  jav a 2 s. c  o m*/
        Sheet sheet0 = workbook.createSheet("CREATED 0");
        sheet0.createRow(0).createCell(0).setCellValue("CELL IN 0");
        Sheet sheet1 = workbook.createSheet("CREATED 1");
        sheet1.createRow(0).createCell(0).setCellValue("CELL IN 1");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            reader.setCurrentSheet(0);
            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(1, r0.length);
            assertEquals("CELL IN 0", r0[0]);
            assertNull(reader.read());

            reader.setCurrentSheet(1);
            String[] r1 = reader.read();
            assertNotNull(r1);
            assertEquals(1, r1.length);
            assertEquals("CELL IN 1", r1[0]);
            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_EMPTY() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from www . j  a v a2s.co  m
        workbook.createSheet();

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {
            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_2_ROWS() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from  w  w  w. j a va 2  s  . c om*/
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellValue("00");
        row0.createCell(1).setCellValue("01");
        Row row1 = sheet.createRow(1);
        row1.createCell(0).setCellValue("10");
        row1.createCell(1).setCellValue("11");
        row1.createCell(2).setCellValue("12");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(2, r0.length);
            assertEquals("00", r0[0]);
            assertEquals("01", r0[1]);

            String[] r1 = reader.read();
            assertNotNull(r1);
            assertEquals(3, r1.length);
            assertEquals("10", r1[0]);
            assertEquals("11", r1[1]);
            assertEquals("12", r1[2]);

            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_3_ROWS_WITH_EMPTY_ROW() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from w ww.ja  va  2  s .  co m
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellValue("00");
        row0.createCell(1).setCellValue("01");
        sheet.createRow(1);
        Row row2 = sheet.createRow(2);
        row2.createCell(0).setCellValue("20");
        row2.createCell(1).setCellValue("21");
        row2.createCell(2).setCellValue("22");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(2, r0.length);
            assertEquals("00", r0[0]);
            assertEquals("01", r0[1]);

            String[] r1 = reader.read();
            assertNotNull(r1);
            assertEquals(0, r1.length);

            String[] r2 = reader.read();
            assertNotNull(r2);
            assertEquals(3, r2.length);
            assertEquals("20", r2[0]);
            assertEquals("21", r2[1]);
            assertEquals("22", r2[2]);

            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_NUMERIC() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from   w ww. j  ava 2s.c o m
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellValue(1234);
        row0.createCell(1).setCellValue(1234.56);

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(2, r0.length);
            assertEquals("1234", r0[0]);
            assertEquals("1234.56", r0[1]);

            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_STRING() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from   w  w  w  . j a va2 s.  c o  m*/
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellValue("CELL 00");
        row0.createCell(1).setCellValue("CELL 01");

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(2, r0.length);
            assertEquals("CELL 00", r0[0]);
            assertEquals("CELL 01", r0[1]);

            assertNull(reader.read());
        }
    }
}

From source file:cherry.goods.excel.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_BLANK() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from w  ww.ja va  2s .  c o  m
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0);
        row0.createCell(1);

        // 
        try (ExcelReader reader = new ExcelReader(workbook)) {

            String[] r0 = reader.read();
            assertNotNull(r0);
            assertEquals(2, r0.length);
            assertEquals("", r0[0]);
            assertEquals("", r0[1]);

            assertNull(reader.read());
        }
    }
}