com.moyosoft.connector.ms.excel
Class Chart

java.lang.Object
  |
  +--com.moyosoft.connector.ms.excel.Chart

All Implemented Interfaces:

Sheet

public class Chart

extends java.lang.Object

implements Sheet

Constructor Summary

Chart(Dispatch dispatch)

Method Summary

void	activate()
void	applyCustomType(ChartType chartType)
void	applyCustomType(ChartType chartType, java.lang.String typeName)
void	applyDataLabels()
void	applyDataLabels(DataLabelsType type)
void	applyDataLabels(DataLabelsType type, boolean legendKey)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName, boolean showCategoryName)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName, boolean showCategoryName, boolean showValue)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName, boolean showCategoryName, boolean showValue, boolean showPercentage)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName, boolean showCategoryName, boolean showValue, boolean showPercentage, boolean showBubbleSize)
void	applyDataLabels(DataLabelsType type, boolean legendKey, boolean autoText, boolean hasLeaderLines, boolean showSeriesName, boolean showCategoryName, boolean showValue, boolean showPercentage, boolean showBubbleSize, java.lang.String separator)
void	autoFormat(int gallery)
void	checkSpelling()
void	checkSpelling(java.lang.String customDictionary)
void	checkSpelling(java.lang.String customDictionary, boolean ignoreUppercase)
void	checkSpelling(java.lang.String customDictionary, boolean ignoreUppercase, boolean alwaysSuggest)
void	copy()
void	copyAfter(Sheet afterSheet)
void	copyBefore(Sheet beforeSheet)
void	copyChartBuild()
void	copyPicture()
void	copyPicture(PictureAppearance appearance)
void	copyPicture(PictureAppearance appearance, CopyPictureFormat format)
void	copyPicture(PictureAppearance appearance, CopyPictureFormat format, PictureAppearance value)
void	delete()
void	deselect()
boolean	export(java.io.File file)
boolean	export(java.io.File file, java.lang.String filterName)
boolean	export(java.io.File file, java.lang.String filterName, boolean interactive)
ChartGroup	getArea3DGroup()
ChartGroup	getAreaGroup(int index)
ChartGroups	getAreaGroups()
Axes	getAxes()
Axis	getAxis(AxisType type)
Axis	getAxis(AxisType type, AxisGroup axisGroup)
ChartGroup	getBar3DGroup()
ChartGroup	getBarGroup(int index)
ChartGroups	getBarGroups()
BarShape	getBarShape()
ChartArea	getChartArea()
void	getChartElement(int x, int y, int elementID, int arg1, int value)
ChartGroups	getChartGroups()
ChartGroup	getChartGroups(int index)
ChartObjects	getChartObjects()
ChartObject	getChartObjects(int index)
ChartTitle	getChartTitle()
ChartType	getChartType()
CheckBox	getCheckBox(int index)
CheckBoxes	getCheckBoxes()
java.lang.String	getCodeName()
ChartGroup	getColumn3DGroup()
ChartGroup	getColumnGroup(int index)
ChartGroups	getColumnGroups()
Corners	getCorners()
DataTable	getDataTable()
int	getDepthPercent()
Dispatch	getDispatch()
DisplayBlanksAs	getDisplayBlanksAs()
ChartGroup	getDoughnutGroup(int index)
ChartGroups	getDoughnutGroups()
Drawing	getDrawing(int index)
Drawings	getDrawings()
DropDown	getDropDown(int index)
DropDowns	getDropDowns()
int	getElevation()
Floor	getFloor()
int	getGapDepth()
GroupBoxes	getGroupBoxes()
GroupBox	getGroupBoxes(int index)
GroupObject	getGroupObject(int index)
GroupObjects	getGroupObjects()
int	getHeightPercent()
Hyperlinks	getHyperlinks()
int	getIndex()
Label	getLabel(int index)
Labels	getLabels()
Legend	getLegend()
Line	getLine(int index)
ChartGroup	getLine3DGroup()
Lines	getLines()
ListBoxes	getListBoxes()
ListBox	getListBoxes(int index)
java.lang.String	getName()
Sheet	getNextSheet()
OptionButton	getOptionButton(int index)
OptionButtons	getOptionButtons()
Oval	getOval(int index)
Ovals	getOvals()
PageSetup	getPageSetup()
int	getPerspective()
Picture	getPicture(int index)
Pictures	getPictures()
ChartGroup	getPie3DGroup()
ChartGroup	getPieGroup(int index)
ChartGroups	getPieGroups()
PlotArea	getPlotArea()
RowCol	getPlotBy()
Sheet	getPreviousSheet()
boolean	getRightAngleAxes()
int	getRotation()
Series	getSeries(int index)
SeriesCollection	getSeriesCollection()
int	getSubType()
ChartGroup	getSurfaceGroup()
Tab	getTab()
int	getType()
SheetVisibility	getVisibility()
Walls	getWalls()
ChartGroup	getXYGroup(int index)
ChartGroups	getXYGroups()
boolean	hasAxis() Deprecated.
boolean	hasAxis(AxisType type)
boolean	hasAxis(AxisType type, AxisGroup group, int index2)
boolean	hasAxis(int index1) Deprecated.
boolean	hasAxis(int index1, int index2) Deprecated.
boolean	hasDataTable()
boolean	hasLegend()
boolean	hasTitle()
boolean	isAutoScaling()
boolean	isPlotVisibleOnly()
boolean	isProtectContents()
boolean	isProtectData()
boolean	isProtectDrawingObjects()
boolean	isProtectFormatting()
boolean	isProtectGoalSeek()
boolean	isProtectionMode()
boolean	isProtectSelection()
boolean	isShowWindow()
boolean	isSizeWithWindow()
boolean	isWallsAndGridlines2D()
Chart	location(ChartLocation where)
Chart	location(ChartLocation where, java.lang.String name)
void	move()
void	moveAfter(Sheet after)
void	moveBefore(Sheet before)
void	paste()
void	paste(PasteType pasteType)
void	printOut()
void	printOut(int copies, boolean preview, boolean collate)
void	printOut(int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
void	printOut(int fromPage, int toPage, int copies)
void	printOut(int fromPage, int toPage, int copies, boolean preview)
void	printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter)
void	printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
void	printPreview()
void	printPreview(boolean enableChanges)
void	protect()
void	protect(java.lang.String password)
void	refresh()
void	saveAs(java.io.File file)
void	saveAs(java.io.File file, FileFormat fileFormat)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup, boolean addToMru)
void	saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup, boolean addToMru, java.lang.String textCodepage)
void	select()
void	select(boolean replace)
void	setAutoScaling(boolean value)
void	setBackgroundPicture(java.lang.String value)
void	setBarShape(BarShape value)
void	setChartType(ChartType value)
void	setDepthPercent(int value)
void	setDisplayBlanksAs(DisplayBlanksAs value)
void	setElevation(int value)
void	setGapDepth(int value)
void	setHasAxis(AxisType type, AxisGroup group, boolean value)
void	setHasAxis(AxisType type, boolean value)
void	setHasAxis(boolean value) Deprecated.
void	setHasDataTable(boolean value)
void	setHasLegend(boolean value)
void	setHasTitle(boolean value)
void	setHeightPercent(int value)
void	setName(java.lang.String value)
void	setPerspective(int value)
void	setPlotBy(RowCol value)
void	setPlotVisibleOnly(boolean value)
void	setProtectData(boolean value)
void	setProtectFormatting(boolean value)
void	setProtectGoalSeek(boolean value)
void	setProtectSelection(boolean value)
void	setRightAngleAxes(boolean value)
void	setRotation(int value)
void	setShowWindow(boolean value)
void	setSizeWithWindow(boolean value)
void	setSourceData(Range source)
void	setSubType(int value)
void	setType(int value)
void	setVisibility(SheetVisibility value)
void	setWallsAndGridlines2D(boolean value)
void	unprotect()
void	unprotect(java.lang.String password)

Methods inherited from class java.lang.Object

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

Constructor Detail

Chart

public Chart(Dispatch dispatch)

Method Detail

getDispatch

public Dispatch getDispatch()

Specified by:

getDispatch in interface Sheet

activate

public void activate()

copy

public void copy()

Specified by:

copy in interface Sheet

copyBefore

public void copyBefore(Sheet beforeSheet)

Specified by:

copyBefore in interface Sheet

copyAfter

public void copyAfter(Sheet afterSheet)

Specified by:

copyAfter in interface Sheet

delete

public void delete()

Specified by:

delete in interface Sheet

getCodeName

public java.lang.String getCodeName()

Specified by:

getCodeName in interface Sheet

getIndex

public int getIndex()

Specified by:

getIndex in interface Sheet

move

public void move()

Specified by:

move in interface Sheet

moveBefore

public void moveBefore(Sheet before)

Specified by:

moveBefore in interface Sheet

moveAfter

public void moveAfter(Sheet after)

Specified by:

moveAfter in interface Sheet

getName

public java.lang.String getName()

Specified by:

getName in interface Sheet

setName

public void setName(java.lang.String value)

Specified by:

setName in interface Sheet

getNextSheet

public Sheet getNextSheet()

Specified by:

getNextSheet in interface Sheet

getPageSetup

public PageSetup getPageSetup()

Specified by:

getPageSetup in interface Sheet

getPreviousSheet

public Sheet getPreviousSheet()

Specified by:

getPreviousSheet in interface Sheet

printPreview

public void printPreview()

Specified by:

printPreview in interface Sheet

printPreview

public void printPreview(boolean enableChanges)

isProtectContents

public boolean isProtectContents()

isProtectDrawingObjects

public boolean isProtectDrawingObjects()

isProtectionMode

public boolean isProtectionMode()

select

public void select()

Specified by:

select in interface Sheet

select

public void select(boolean replace)

unprotect

public void unprotect()

unprotect

public void unprotect(java.lang.String password)

getVisibility

public SheetVisibility getVisibility()

Specified by:

getVisibility in interface Sheet

setVisibility

public void setVisibility(SheetVisibility value)

Specified by:

setVisibility in interface Sheet

getArea3DGroup

public ChartGroup getArea3DGroup()

getAreaGroups

public ChartGroups getAreaGroups()

getAreaGroup

public ChartGroup getAreaGroup(int index)

autoFormat

public void autoFormat(int gallery)

isAutoScaling

public boolean isAutoScaling()

setAutoScaling

public void setAutoScaling(boolean value)

getAxes

public Axes getAxes()

getAxis

public Axis getAxis(AxisType type)

getAxis

public Axis getAxis(AxisType type,
                    AxisGroup axisGroup)

setBackgroundPicture

public void setBackgroundPicture(java.lang.String value)

getBar3DGroup

public ChartGroup getBar3DGroup()

getBarGroups

public ChartGroups getBarGroups()

getBarGroup

public ChartGroup getBarGroup(int index)

getChartArea

public ChartArea getChartArea()

getChartGroups

public ChartGroups getChartGroups()

getChartGroups

public ChartGroup getChartGroups(int index)

getChartObjects

public ChartObjects getChartObjects()

getChartObjects

public ChartObject getChartObjects(int index)

getChartTitle

public ChartTitle getChartTitle()

getCheckBoxes

public CheckBoxes getCheckBoxes()

getCheckBox

public CheckBox getCheckBox(int index)

checkSpelling

public void checkSpelling()

checkSpelling

public void checkSpelling(java.lang.String customDictionary)

checkSpelling

public void checkSpelling(java.lang.String customDictionary,
                          boolean ignoreUppercase)

checkSpelling

public void checkSpelling(java.lang.String customDictionary,
                          boolean ignoreUppercase,
                          boolean alwaysSuggest)

getColumn3DGroup

public ChartGroup getColumn3DGroup()

getColumnGroups

public ChartGroups getColumnGroups()

getColumnGroup

public ChartGroup getColumnGroup(int index)

copyPicture

public void copyPicture()

copyPicture

public void copyPicture(PictureAppearance appearance)

copyPicture

public void copyPicture(PictureAppearance appearance,
                        CopyPictureFormat format)

copyPicture

public void copyPicture(PictureAppearance appearance,
                        CopyPictureFormat format,
                        PictureAppearance value)

getCorners

public Corners getCorners()

getDataTable

public DataTable getDataTable()

getDepthPercent

public int getDepthPercent()

setDepthPercent

public void setDepthPercent(int value)

deselect

public void deselect()

getDisplayBlanksAs

public DisplayBlanksAs getDisplayBlanksAs()

setDisplayBlanksAs

public void setDisplayBlanksAs(DisplayBlanksAs value)

getDoughnutGroups

public ChartGroups getDoughnutGroups()

getDoughnutGroup

public ChartGroup getDoughnutGroup(int index)

getDrawings

public Drawings getDrawings()

getDrawing

public Drawing getDrawing(int index)

getDropDowns

public DropDowns getDropDowns()

getDropDown

public DropDown getDropDown(int index)

getElevation

public int getElevation()

setElevation

public void setElevation(int value)

getFloor

public Floor getFloor()

getGapDepth

public int getGapDepth()

setGapDepth

public void setGapDepth(int value)

getGroupBoxes

public GroupBoxes getGroupBoxes()

getGroupBoxes

public GroupBox getGroupBoxes(int index)

getGroupObjects

public GroupObjects getGroupObjects()

getGroupObject

public GroupObject getGroupObject(int index)

hasAxis

public boolean hasAxis()

Deprecated.

hasAxis

public boolean hasAxis(int index1)

Deprecated.

hasAxis

public boolean hasAxis(int index1,
                       int index2)

Deprecated.

hasAxis

public boolean hasAxis(AxisType type)

hasAxis

public boolean hasAxis(AxisType type,
                       AxisGroup group,
                       int index2)

setHasAxis

public void setHasAxis(boolean value)

Deprecated.

setHasAxis

public void setHasAxis(AxisType type,
                       boolean value)

setHasAxis

public void setHasAxis(AxisType type,
                       AxisGroup group,
                       boolean value)

hasDataTable

public boolean hasDataTable()

setHasDataTable

public void setHasDataTable(boolean value)

hasLegend

public boolean hasLegend()

setHasLegend

public void setHasLegend(boolean value)

hasTitle

public boolean hasTitle()

setHasTitle

public void setHasTitle(boolean value)

getHeightPercent

public int getHeightPercent()

setHeightPercent

public void setHeightPercent(int value)

getHyperlinks

public Hyperlinks getHyperlinks()

getLabels

public Labels getLabels()

getLabel

public Label getLabel(int index)

getLegend

public Legend getLegend()

getLine3DGroup

public ChartGroup getLine3DGroup()

getLines

public Lines getLines()

getLine

public Line getLine(int index)

getListBoxes

public ListBoxes getListBoxes()

getListBoxes

public ListBox getListBoxes(int index)

location

public Chart location(ChartLocation where)

location

public Chart location(ChartLocation where,
                      java.lang.String name)

getOptionButtons

public OptionButtons getOptionButtons()

getOptionButton

public OptionButton getOptionButton(int index)

getOvals

public Ovals getOvals()

getOval

public Oval getOval(int index)

paste

public void paste()

Specified by:

paste in interface Sheet

paste

public void paste(PasteType pasteType)

getPerspective

public int getPerspective()

setPerspective

public void setPerspective(int value)

getPictures

public Pictures getPictures()

getPicture

public Picture getPicture(int index)

getPie3DGroup

public ChartGroup getPie3DGroup()

getPieGroups

public ChartGroups getPieGroups()

getPieGroup

public ChartGroup getPieGroup(int index)

getPlotArea

public PlotArea getPlotArea()

isPlotVisibleOnly

public boolean isPlotVisibleOnly()

setPlotVisibleOnly

public void setPlotVisibleOnly(boolean value)

getRightAngleAxes

public boolean getRightAngleAxes()

setRightAngleAxes

public void setRightAngleAxes(boolean value)

getRotation

public int getRotation()

setRotation

public void setRotation(int value)

getSeriesCollection

public SeriesCollection getSeriesCollection()

getSeries

public Series getSeries(int index)

isSizeWithWindow

public boolean isSizeWithWindow()

setSizeWithWindow

public void setSizeWithWindow(boolean value)

isShowWindow

public boolean isShowWindow()

setShowWindow

public void setShowWindow(boolean value)

getSubType

public int getSubType()

setSubType

public void setSubType(int value)

getSurfaceGroup

public ChartGroup getSurfaceGroup()

getType

public int getType()

setType

public void setType(int value)

getChartType

public ChartType getChartType()

setChartType

public void setChartType(ChartType value)

applyCustomType

public void applyCustomType(ChartType chartType)

applyCustomType

public void applyCustomType(ChartType chartType,
                            java.lang.String typeName)

getWalls

public Walls getWalls()

isWallsAndGridlines2D

public boolean isWallsAndGridlines2D()

setWallsAndGridlines2D

public void setWallsAndGridlines2D(boolean value)

getXYGroups

public ChartGroups getXYGroups()

getXYGroup

public ChartGroup getXYGroup(int index)

getBarShape

public BarShape getBarShape()

setBarShape

public void setBarShape(BarShape value)

getPlotBy

public RowCol getPlotBy()

setPlotBy

public void setPlotBy(RowCol value)

copyChartBuild

public void copyChartBuild()

isProtectFormatting

public boolean isProtectFormatting()

setProtectFormatting

public void setProtectFormatting(boolean value)

isProtectData

public boolean isProtectData()

setProtectData

public void setProtectData(boolean value)

isProtectGoalSeek

public boolean isProtectGoalSeek()

setProtectGoalSeek

public void setProtectGoalSeek(boolean value)

isProtectSelection

public boolean isProtectSelection()

setProtectSelection

public void setProtectSelection(boolean value)

getChartElement

public void getChartElement(int x,
                            int y,
                            int elementID,
                            int arg1,
                            int value)

setSourceData

public void setSourceData(Range source)

export

public boolean export(java.io.File file)

export

public boolean export(java.io.File file,
                      java.lang.String filterName)

export

public boolean export(java.io.File file,
                      java.lang.String filterName,
                      boolean interactive)

refresh

public void refresh()

printOut

public void printOut()

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview,
                     java.lang.String activePrinter)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copies,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFilename)

printOut

public void printOut(int copies,
                     boolean preview,
                     boolean collate)

printOut

public void printOut(int copies,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFilename)

getTab

public Tab getTab()

applyDataLabels

public void applyDataLabels()

applyDataLabels

public void applyDataLabels(DataLabelsType type)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName,
                            boolean showCategoryName)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName,
                            boolean showCategoryName,
                            boolean showValue)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName,
                            boolean showCategoryName,
                            boolean showValue,
                            boolean showPercentage)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName,
                            boolean showCategoryName,
                            boolean showValue,
                            boolean showPercentage,
                            boolean showBubbleSize)

applyDataLabels

public void applyDataLabels(DataLabelsType type,
                            boolean legendKey,
                            boolean autoText,
                            boolean hasLeaderLines,
                            boolean showSeriesName,
                            boolean showCategoryName,
                            boolean showValue,
                            boolean showPercentage,
                            boolean showBubbleSize,
                            java.lang.String separator)

saveAs

public void saveAs(java.io.File file)

Specified by:

saveAs in interface Sheet

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat)

Specified by:

saveAs in interface Sheet

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password)

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password,
                   java.lang.String writeResPassword)

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password,
                   java.lang.String writeResPassword,
                   boolean readOnlyRecommended)

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password,
                   java.lang.String writeResPassword,
                   boolean readOnlyRecommended,
                   boolean createBackup)

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password,
                   java.lang.String writeResPassword,
                   boolean readOnlyRecommended,
                   boolean createBackup,
                   boolean addToMru)

saveAs

public void saveAs(java.io.File file,
                   FileFormat fileFormat,
                   java.lang.String password,
                   java.lang.String writeResPassword,
                   boolean readOnlyRecommended,
                   boolean createBackup,
                   boolean addToMru,
                   java.lang.String textCodepage)

protect

public void protect()

protect

public void protect(java.lang.String password)