Example #1
0
 @Test
 public void testEmpty() {
   Sheet sheet = workbook.createSheet("test");
   Row row = sheet.createRow();
   assertEquals(0, row.getRowNo());
   writer.write(workbook, createFileOutputStream());
   Sheet result = readGeneratedFile().getSheet("test");
   assertNull(result.getValueAt(0, 0));
 }
Example #2
0
 @Test
 public void testString() {
   Sheet sheet = workbook.createSheet("test");
   Row row = sheet.createRow();
   row.getCellAt(0).setCellValue(new StringValue("haha"));
   writer.write(workbook, createFileOutputStream());
   Sheet result = readGeneratedFile().getSheet("test");
   assertEquals("haha", result.getValueAt(0, 0));
 }
Example #3
0
 @Test
 public void testNumeric() {
   Sheet sheet = workbook.createSheet("test");
   Row row = sheet.createRow();
   Double number = Double.valueOf(42);
   row.getCellAt(0).setCellValue(new NumericValue(number));
   writer.write(workbook, createFileOutputStream());
   Sheet result = readGeneratedFile().getSheet("test");
   assertEquals(number, result.getValueAt(0, 0));
 }
Example #4
0
 @Test
 public void testFormula() {
   Sheet sheet = workbook.createSheet("test");
   Row row = sheet.createRow();
   row.getCellAt(0).setCellValue(new NumericValue(1D));
   row.getCellAt(1).setCellValue(new NumericValue(2D));
   row.getCellAt(2).setCellValue(new FormulaValue("SUM(A1:B1)"));
   writer.write(workbook, createFileOutputStream());
   Sheet result = readGeneratedFile().getSheet("test");
   assertEquals("SUM(A1:B1)", result.getValueAt(0, 2));
 }
Example #5
0
 @Test
 public void testBoolean() {
   Sheet sheet = workbook.createSheet("test");
   Row row = sheet.createRow();
   row.getCellAt(0).setCellValue(new BooleanValue(true));
   row.getCellAt(1).setCellValue(new BooleanValue(false));
   writer.write(workbook, createFileOutputStream());
   Sheet result = readGeneratedFile().getSheet("test");
   assertEquals(Boolean.TRUE, result.getValueAt(0, 0));
   assertEquals(Boolean.FALSE, result.getValueAt(0, 1));
 }
Example #6
0
 @Test
 public void testSheets() {
   workbook.createSheet("first");
   workbook.createSheet("second");
   workbook.createSheet("third");
   writer.write(workbook, createFileOutputStream());
   Workbook result = readGeneratedFile();
   assertEquals(3, result.getSheetCount());
   assertTrue(result.containsSheet("first"));
   assertTrue(result.containsSheet("second"));
   assertTrue(result.containsSheet("third"));
 }