@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));
}
@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));
}
@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));
}
@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));
}
@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));
}
@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"));
}