@Test
public void writeCell() throws Exception {

    final ExcelChartSheet excelChartSheet = new ExcelChartSheetDefault(workbook, ChartType.bar.toString());
    final Row row = excelChartSheet.createRow();
    excelChartSheet.writeCell(null, row, 0);
    excelChartSheet.writeCell(Boolean.TRUE, row, 1);
    excelChartSheet.writeCell("text", row, 2);
    excelChartSheet.writeCell(1, row, 3);
    Assert.assertEquals(CellType.BLANK, row.getCell(0).getCellTypeEnum());
    Assert.assertEquals("Yes", row.getCell(1).getStringCellValue());
    Assert.assertEquals(CellType.STRING, row.getCell(2).getCellTypeEnum());
    Assert.assertEquals(CellType.NUMERIC, row.getCell(3).getCellTypeEnum());
}