/* FormulaEvaluatorTest.java
Purpose:
Description:
History:
Mar 17, 2010 11:55:42 AM, Created by henrichen
Copyright (C) 2010 Potix Corporation. All Rights Reserved.
*/
package org.zkoss.zss.model.impl;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNull;
import static org.junit.Assert.assertTrue;
import java.io.InputStream;
import java.util.List;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.zkoss.poi.hssf.usermodel.HSSFChart;
import org.zkoss.poi.hssf.usermodel.HSSFChartX;
import org.zkoss.poi.hssf.usermodel.HSSFSheet;
import org.zkoss.poi.hssf.usermodel.HSSFWorkbook;
import org.zkoss.poi.hssf.usermodel.HSSFChart.HSSFSeries;
import org.zkoss.poi.ss.usermodel.Chart;
import org.zkoss.poi.ss.usermodel.ZssChartX;
import org.zkoss.util.resource.ClassLocator;
import org.zkoss.zss.model.Book;
import org.zkoss.zssex.model.impl.DrawingManagerImpl;
/**
* Test chart anchor and type.
* @author henrichen
*
*/
public class PiechartXlsChartTest {
private Book _book;
/**
* @throws java.lang.Exception
*/
@Before
public void setUp() throws Exception {
final String filename = "piechart.xls";
final InputStream is = new ClassLocator().getResourceAsStream(filename);
_book = (Book) new ExcelImporter().imports(is, filename);
assertTrue(_book instanceof Book);
assertTrue(_book instanceof HSSFBookImpl);
assertTrue(_book instanceof HSSFWorkbook);
assertEquals(filename, ((Book)_book).getBookName());
assertEquals("Sheet1", _book.getSheetName(0));
assertEquals(0, _book.getSheetIndex("Sheet1"));
}
/**
* @throws java.lang.Exception
*/
@After
public void tearDown() throws Exception {
_book = null;
}
@Test
public void testColumnchart() {
HSSFSheet sheet1 = (HSSFSheet) _book.getSheet("Sheet1");
List<ZssChartX> chartXes = new DrawingManagerImpl(sheet1).getChartXs();
assertEquals(1, chartXes.size());
HSSFChartX chartX = (HSSFChartX) chartXes.get(0);
HSSFChart chart = (HSSFChart) chartX.getChartInfo();
assertNull(chart.getChartTitle());
System.out.println("getgetChartWidth():"+chart.getChartWidth());
HSSFSeries[] series = chart.getSeries();
assertEquals(1, series.length);
for(int j = 0; j < series.length; ++j) {
HSSFSeries ser = series[j];
assertEquals(3, ser.getNumValues());
assertEquals("2003", ser.getSeriesTitle());
assertEquals(1, ser.getValueType());
System.out.println("ser.getDataCategoryLabels():"+ser.getDataCategoryLabels());
System.out.println("ser.getDataName():"+ser.getDataName());
System.out.println("ser.getDataSecondaryCategoryLabels():"+ser.getDataSecondaryCategoryLabels());
System.out.println("ser.getDataValues():"+ser.getDataValues());
System.out.println("ser.getSeries():"+ser.getSeries());
}
}
}