public void TestGetCharts()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("chart_sheet.xlsx");
XSSFSheet ns = (XSSFSheet)wb.GetSheetAt(0);
XSSFChartSheet cs = (XSSFChartSheet)wb.GetSheetAt(2);
Assert.AreEqual(0, (ns.CreateDrawingPatriarch() as XSSFDrawing).GetCharts().Count);
Assert.AreEqual(1, (cs.CreateDrawingPatriarch() as XSSFDrawing).GetCharts().Count);
XSSFChart chart = (cs.CreateDrawingPatriarch() as XSSFDrawing).GetCharts()[0];
Assert.AreEqual(null, chart.GetTitle());
}
public void TestGetCharts()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("WithThreeCharts.xlsx");
XSSFSheet s1 = (XSSFSheet)wb.GetSheetAt(0);
XSSFSheet s2 = (XSSFSheet)wb.GetSheetAt(1);
XSSFSheet s3 = (XSSFSheet)wb.GetSheetAt(2);
Assert.AreEqual(0, (s1.CreateDrawingPatriarch() as XSSFDrawing).GetCharts().Count);
Assert.AreEqual(2, (s2.CreateDrawingPatriarch() as XSSFDrawing).GetCharts().Count);
Assert.AreEqual(1, (s3.CreateDrawingPatriarch() as XSSFDrawing).GetCharts().Count);
// Check the titles
XSSFChart chart = (s2.CreateDrawingPatriarch() as XSSFDrawing).GetCharts()[(0)];
Assert.AreEqual(null, chart.GetTitle());
chart = (s2.CreateDrawingPatriarch() as XSSFDrawing).GetCharts()[(1)];
Assert.AreEqual("Pie Chart Title Thingy", chart.GetTitle().String);
chart = (s3.CreateDrawingPatriarch() as XSSFDrawing).GetCharts()[(0)];
Assert.AreEqual("Sheet 3 Chart with Title", chart.GetTitle().String);
}