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.ExcelReaderTest.java

License:Apache License

@Test
public void testRead_BOOLEAN() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*w  w  w.j  ava2  s.c om*/
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellValue(true);
        row0.createCell(1).setCellValue(false);

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

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

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

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

License:Apache License

@Test
public void testRead_ERROR() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*w w w .  j  av  a  2 s  .  c  om*/
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellErrorValue((byte) 0);
        row0.createCell(1).setCellErrorValue((byte) 0);

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

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

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

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

License:Apache License

@Test
public void testRead_FORMULA_NUMERIC() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from w ww .  j a v a2  s  .com
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellFormula("1200+34");
        row0.createCell(1).setCellFormula("1200+34.56");
        FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
        evaluator.evaluateAll();

        // 
        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_FORMULA_STRING() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from  ww w .j  a  v  a  2 s.  c o  m*/
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellFormula("\"CELL\"&\"00\"");
        row0.createCell(1).setCellFormula("\"CELL\"&\"01\"");
        FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
        evaluator.evaluateAll();

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

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

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

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

License:Apache License

@Test
public void testRead_FORMULA_BOOLEAN() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // // w  ww  .  j a  va  2 s.  c  o m
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellFormula("1=1");
        row0.createCell(1).setCellFormula("1=0");
        FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
        evaluator.evaluateAll();

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

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

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

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

License:Apache License

@Test
public void testRead_FORMULA_ERROR() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from  w  w  w .j a va2 s  .co m
        Sheet sheet = workbook.createSheet();
        Row row0 = sheet.createRow(0);
        row0.createCell(0).setCellErrorValue((byte) 0);
        row0.createCell(1).setCellFormula("A1");
        FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
        evaluator.evaluateAll();

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

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

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

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

License:Apache License

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

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            assertEquals(3, writer.getNumberOfSheets());
        }
    }
}

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

License:Apache License

@Test
public void testGetSheetName() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from  www . ja  va2  s .c  o  m*/
        workbook.createSheet("CREATED 0");
        workbook.createSheet("CREATED 1");
        workbook.createSheet("CREATED 2");

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

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

License:Apache License

@Test
public void testSetCurrentSheet() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from www  . j  a v a2s. c  o  m*/
        Sheet sheet0 = workbook.createSheet("CREATED 0");
        Sheet sheet1 = workbook.createSheet("CREATED 1");

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            writer.setCurrentSheet(0);
            writer.write("CELL IN 0");
            writer.setCurrentSheet(1);
            writer.write("CELL IN 1");

            assertEquals("CELL IN 0", sheet0.getRow(0).getCell(0).getStringCellValue());
            assertEquals("CELL IN 1", sheet1.getRow(0).getCell(0).getStringCellValue());
        }
    }
}

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

License:Apache License

@Test
public void testWrite_2_COLS_2_ROWS() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // /*from ww w  .  ja  va 2  s.co  m*/
        Sheet sheet = workbook.createSheet("CREATED 0");

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            writer.write("CELL 00", "CELL 01");
            writer.write("CELL 10", "CELL 11");

            assertEquals("CELL 00", sheet.getRow(0).getCell(0).getStringCellValue());
            assertEquals("CELL 01", sheet.getRow(0).getCell(1).getStringCellValue());
            assertEquals("CELL 10", sheet.getRow(1).getCell(0).getStringCellValue());
            assertEquals("CELL 11", sheet.getRow(1).getCell(1).getStringCellValue());
        }
    }
}