org.zkoss.zssex.util
Class ChartHelper

java.lang.Object
  org.zkoss.zssex.util.ChartHelper

public class ChartHelper
extends java.lang.Object

Internal Use Only. Helper Utility class for handling Chart.

Author:

ashish

Constructor Summary

ChartHelper()

Method Summary

static org.zkoss.zul.Chart	createChart(org.zkoss.poi.ss.usermodel.Chart poiChart)
static org.zkoss.zul.Chart	createChart(org.zkoss.poi.ss.usermodel.ChartInfo chartInfo) Creates Chart based on the ChartInfo
static void	drawChart(ChartDrawer drawer, org.zkoss.zul.Chart zchart, Worksheet sheet, org.zkoss.poi.ss.usermodel.ZssChartX poiChart)
static int	emuToPx(int emu) Convert EMU to pixel. 1 twip == 635 emu
static org.zkoss.poi.ss.util.AreaReference	getAreaReference(org.zkoss.poi.hssf.usermodel.HSSFSheet sheet, org.zkoss.poi.hssf.record.chart.LinkedDataRecord linkedDataRecord) Returns the AreaReference represented by LinkedDataRecord
static java.lang.String	getChartType(org.zkoss.poi.ss.usermodel.Chart poiChart)
static java.lang.String	getChartType(org.zkoss.poi.ss.usermodel.Chart poiChart, org.zkoss.poi.ss.usermodel.charts.ChartGrouping grouping)
static java.lang.String	getChartType(org.zkoss.poi.ss.usermodel.ChartInfo chartInfo) Returns type of chart
static java.lang.String[]	getLiterals(org.zkoss.poi.hssf.usermodel.HSSFWorkbook book, org.zkoss.poi.hssf.record.LabelSSTRecord[] labelRecords)
static boolean	isContiguous(org.zkoss.poi.ss.formula.ptg.Ptg[] ptgs)
static org.zkoss.poi.ss.util.AreaReference	prepareSingleReference(org.zkoss.poi.hssf.usermodel.HSSFSheet sheet, org.zkoss.poi.ss.formula.ptg.Ptg[] ptgs)
static int	pxToEmu(int px) convert pixel to EMU

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ChartHelper

public ChartHelper()

Method Detail

emuToPx

public static int emuToPx(int emu)

Convert EMU to pixel. 1 twip == 635 emu

pxToEmu

public static int pxToEmu(int px)

convert pixel to EMU

getChartType

public static java.lang.String getChartType(org.zkoss.poi.ss.usermodel.ChartInfo chartInfo)

Returns type of chart

Parameters:

chartInfo -

Returns:

chart type in String such as ("area", "bar", "line", "scatter", etc.)

getAreaReference

public static org.zkoss.poi.ss.util.AreaReference getAreaReference(org.zkoss.poi.hssf.usermodel.HSSFSheet sheet,
                                                                   org.zkoss.poi.hssf.record.chart.LinkedDataRecord linkedDataRecord)

Returns the AreaReference represented by LinkedDataRecord

Parameters:

sheet -

linkedDataRecord -

Returns:

the AreaReference represented by LinkedDataRecord

prepareSingleReference

public static org.zkoss.poi.ss.util.AreaReference prepareSingleReference(org.zkoss.poi.hssf.usermodel.HSSFSheet sheet,
                                                                         org.zkoss.poi.ss.formula.ptg.Ptg[] ptgs)

createChart

public static org.zkoss.zul.Chart createChart(org.zkoss.poi.ss.usermodel.ChartInfo chartInfo)

Creates Chart based on the ChartInfo

Parameters:

chartInfo -

Returns:

the created Chart based on the ChartInfo

getLiterals

public static java.lang.String[] getLiterals(org.zkoss.poi.hssf.usermodel.HSSFWorkbook book,
                                             org.zkoss.poi.hssf.record.LabelSSTRecord[] labelRecords)

isContiguous

public static boolean isContiguous(org.zkoss.poi.ss.formula.ptg.Ptg[] ptgs)

getChartType

public static java.lang.String getChartType(org.zkoss.poi.ss.usermodel.Chart poiChart,
                                            org.zkoss.poi.ss.usermodel.charts.ChartGrouping grouping)

getChartType

public static java.lang.String getChartType(org.zkoss.poi.ss.usermodel.Chart poiChart)

createChart

public static org.zkoss.zul.Chart createChart(org.zkoss.poi.ss.usermodel.Chart poiChart)

drawChart

public static void drawChart(ChartDrawer drawer,
                             org.zkoss.zul.Chart zchart,
                             Worksheet sheet,
                             org.zkoss.poi.ss.usermodel.ZssChartX poiChart)