com.moyosoft.connector.ms.excel
Class Worksheet

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

All Implemented Interfaces:

Sheet

public class Worksheet

extends java.lang.Object

implements Sheet

Constructor Summary

Worksheet(Dispatch dispatch)

Method Summary

void	activate()
void	calculate()
void	checkSpelling()
void	checkSpelling(java.lang.String customDictionaryFilename)
void	checkSpelling(java.lang.String customDictionaryFilename, boolean ignoreUppercase)
void	checkSpelling(java.lang.String customDictionaryFilename, boolean ignoreUppercase, boolean alwaysSuggest)
void	checkSpelling(java.lang.String customDictionaryFilename, boolean ignoreUppercase, boolean alwaysSuggest, int spellLang)
void	circleInvalid()
void	clearArrows()
void	clearCircles()
void	copy()
void	copyAfter(Sheet afterSheet)
void	copyBefore(Sheet beforeSheet)
void	delete()
java.lang.Object	evaluate(java.lang.String value)
AutoFilter	getAutoFilter()
Range	getCell(int rowIndex, int columnIndex)
Range	getCell(int rowIndex, java.lang.String columnName)
Range	getCells()
ChartObject	getChartObject(int index)
ChartObjects	getChartObjects()
Range	getCircularReference()
java.lang.String	getCodeName()
Range	getColumns()
Comments	getComments()
ConsolidationFunction	getConsolidationFunction()
CustomProperties	getCustomProperties()
Dispatch	getDispatch()
EnableSelection	getEnableSelection()
GroupBox	getGroupBox(int index)
GroupBoxes	getGroupBoxes()
GroupObject	getGroupObject(int index)
GroupObjects	getGroupObjects()
HPageBreaks	getHPageBreaks()
Hyperlinks	getHyperlinks()
int	getIndex()
Label	getLabel(int index)
Labels	getLabels()
Line	getLine(int index)
Lines	getLines()
ListBox	getListBox(int index)
ListBoxes	getListBoxes()
ListObjects	getListObjects()
java.lang.String	getName()
Names	getNames()
Sheet	getNextSheet()
OptionButton	getOptionButton(int index)
OptionButtons	getOptionButtons()
Outline	getOutline()
Oval	getOval(int index)
Ovals	getOvals()
PageSetup	getPageSetup()
Picture	getPicture(int index)
Pictures	getPictures()
Sheet	getPreviousSheet()
Protection	getProtection()
QueryTables	getQueryTables()
Range	getRange(int rowIndex, int columnIndex)
Range	getRange(int rowIndex, java.lang.String columnName)
Range	getRange(java.lang.String cell1)
Range	getRange(java.lang.String cell1, Range cell2)
Range	getRange(java.lang.String cell1, java.lang.String cell2)
Range	getRows()
java.lang.String	getScrollArea()
ScrollBar	getScrollBar(int index)
ScrollBars	getScrollBars()
SmartTags	getSmartTags()
Spinner	getSpinner(int index)
Spinners	getSpinners()
double	getStandardHeight()
double	getStandardWidth()
Tab	getTab()
TextBox	getTextBox(int index)
TextBoxes	getTextBoxes()
SheetType	getType()
Range	getUsedRange()
SheetVisibility	getVisibility()
VPageBreaks	getVPageBreaks()
boolean	isAutoFilterMode()
boolean	isDisplayAutomaticPageBreaks()
boolean	isDisplayPageBreaks()
boolean	isDisplayRightToLeft()
boolean	isEnableAutoFilter()
boolean	isEnableCalculation()
boolean	isEnableOutlining()
boolean	isEnablePivotTable()
boolean	isFilterMode()
boolean	isProtectContents()
boolean	isProtectDrawingObjects()
boolean	isProtectionMode()
boolean	isProtectScenarios()
boolean	isTransitionExpEval()
boolean	isTransitionFormEntry()
void	move()
void	moveAfter(Sheet after)
void	moveBefore(Sheet before)
void	paste()
void	paste(Range destination)
void	paste(Range destination, boolean link)
void	pasteSpecial()
void	pasteSpecial(java.lang.String clipboardFormat)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link, boolean displayAsIcon)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link, boolean displayAsIcon, java.lang.String iconFileName)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link, boolean displayAsIcon, java.lang.String iconFileName, int iconIndex)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link, boolean displayAsIcon, java.lang.String iconFileName, int iconIndex, java.lang.String iconLabel)
void	pasteSpecial(java.lang.String clipboardFormat, boolean link, boolean displayAsIcon, java.lang.String iconFileName, int iconIndex, java.lang.String iconLabel, boolean noHTMLFormatting)
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	protect()
void	protect(java.lang.String password)
void	resetAllPageBreaks()
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	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, TextVisualLayoutType textVisualLayout)
void	select()
void	select(java.lang.String replace)
void	setAutoFilterMode(boolean value)
void	setBackgroundPicture(java.lang.String value)
void	setDisplayAutomaticPageBreaks(boolean value)
void	setDisplayPageBreaks(boolean value)
void	setDisplayRightToLeft(boolean value)
void	setEnableAutoFilter(boolean value)
void	setEnableCalculation(boolean value)
void	setEnableOutlining(boolean value)
void	setEnablePivotTable(boolean value)
void	setEnableSelection(EnableSelection value)
void	setName(java.lang.String value)
void	setScrollArea(java.lang.String rangeWhereScrollingIsAllowed)
void	setStandardWidth(double value)
void	setTransitionExpEval(boolean value)
void	setTransitionFormEntry(boolean value)
void	setVisibility(SheetVisibility value)
void	showAllData()
void	showDataForm()
void	unprotect()
void	unprotect(java.lang.String password)
Range	xmlDataQuery(java.lang.String xPath)
Range	xmlDataQuery(java.lang.String xPath, java.lang.String selectionNamespaces)
Range	xmlDataQuery(java.lang.String xPath, java.lang.String selectionNamespaces, XmlMap map)
Range	xmlMapQuery(java.lang.String xPath)
Range	xmlMapQuery(java.lang.String xPath, java.lang.String selectionNamespaces)
Range	xmlMapQuery(java.lang.String xPath, java.lang.String selectionNamespaces, XmlMap map)

Methods inherited from class java.lang.Object

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

Constructor Detail

Worksheet

public Worksheet(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

isProtectContents

public boolean isProtectContents()

isProtectDrawingObjects

public boolean isProtectDrawingObjects()

isProtectionMode

public boolean isProtectionMode()

isProtectScenarios

public boolean isProtectScenarios()

select

public void select()

Specified by:

select in interface Sheet

select

public void select(java.lang.String 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

isTransitionExpEval

public boolean isTransitionExpEval()

setTransitionExpEval

public void setTransitionExpEval(boolean value)

isAutoFilterMode

public boolean isAutoFilterMode()

setAutoFilterMode

public void setAutoFilterMode(boolean value)

setBackgroundPicture

public void setBackgroundPicture(java.lang.String value)

calculate

public void calculate()

isEnableCalculation

public boolean isEnableCalculation()

setEnableCalculation

public void setEnableCalculation(boolean value)

getCells

public Range getCells()

getChartObjects

public ChartObjects getChartObjects()

getChartObject

public ChartObject getChartObject(int index)

checkSpelling

public void checkSpelling()

checkSpelling

public void checkSpelling(java.lang.String customDictionaryFilename)

checkSpelling

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

checkSpelling

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

checkSpelling

public void checkSpelling(java.lang.String customDictionaryFilename,
                          boolean ignoreUppercase,
                          boolean alwaysSuggest,
                          int spellLang)

getCircularReference

public Range getCircularReference()

clearArrows

public void clearArrows()

getColumns

public Range getColumns()

getConsolidationFunction

public ConsolidationFunction getConsolidationFunction()

isDisplayAutomaticPageBreaks

public boolean isDisplayAutomaticPageBreaks()

setDisplayAutomaticPageBreaks

public void setDisplayAutomaticPageBreaks(boolean value)

isEnableAutoFilter

public boolean isEnableAutoFilter()

setEnableAutoFilter

public void setEnableAutoFilter(boolean value)

getEnableSelection

public EnableSelection getEnableSelection()

setEnableSelection

public void setEnableSelection(EnableSelection value)

isEnableOutlining

public boolean isEnableOutlining()

setEnableOutlining

public void setEnableOutlining(boolean value)

isEnablePivotTable

public boolean isEnablePivotTable()

setEnablePivotTable

public void setEnablePivotTable(boolean value)

evaluate

public java.lang.Object evaluate(java.lang.String value)

isFilterMode

public boolean isFilterMode()

resetAllPageBreaks

public void resetAllPageBreaks()

getGroupBoxes

public GroupBoxes getGroupBoxes()

getGroupBox

public GroupBox getGroupBox(int index)

getGroupObjects

public GroupObjects getGroupObjects()

getGroupObject

public GroupObject getGroupObject(int index)

getLabels

public Labels getLabels()

getLabel

public Label getLabel(int index)

getLines

public Lines getLines()

getLine

public Line getLine(int index)

getListBoxes

public ListBoxes getListBoxes()

getListBox

public ListBox getListBox(int index)

getNames

public Names getNames()

getOptionButtons

public OptionButtons getOptionButtons()

getOptionButton

public OptionButton getOptionButton(int index)

getOutline

public Outline getOutline()

getOvals

public Ovals getOvals()

getOval

public Oval getOval(int index)

paste

public void paste()

Specified by:

paste in interface Sheet

paste

public void paste(Range destination)

paste

public void paste(Range destination,
                  boolean link)

getPictures

public Pictures getPictures()

getPicture

public Picture getPicture(int index)

getRange

public Range getRange(java.lang.String cell1)

getRange

public Range getRange(java.lang.String cell1,
                      java.lang.String cell2)

getRange

public Range getRange(java.lang.String cell1,
                      Range cell2)

getCell

public Range getCell(int rowIndex,
                     int columnIndex)

getCell

public Range getCell(int rowIndex,
                     java.lang.String columnName)

getRange

public Range getRange(int rowIndex,
                      int columnIndex)

getRange

public Range getRange(int rowIndex,
                      java.lang.String columnName)

getRows

public Range getRows()

getScrollArea

public java.lang.String getScrollArea()

setScrollArea

public void setScrollArea(java.lang.String rangeWhereScrollingIsAllowed)

getScrollBars

public ScrollBars getScrollBars()

getScrollBar

public ScrollBar getScrollBar(int index)

showAllData

public void showAllData()

showDataForm

public void showDataForm()

getSpinners

public Spinners getSpinners()

getSpinner

public Spinner getSpinner(int index)

getStandardHeight

public double getStandardHeight()

getStandardWidth

public double getStandardWidth()

setStandardWidth

public void setStandardWidth(double value)

getTextBoxes

public TextBoxes getTextBoxes()

getTextBox

public TextBox getTextBox(int index)

isTransitionFormEntry

public boolean isTransitionFormEntry()

setTransitionFormEntry

public void setTransitionFormEntry(boolean value)

getType

public SheetType getType()

getUsedRange

public Range getUsedRange()

getHPageBreaks

public HPageBreaks getHPageBreaks()

getVPageBreaks

public VPageBreaks getVPageBreaks()

getQueryTables

public QueryTables getQueryTables()

isDisplayPageBreaks

public boolean isDisplayPageBreaks()

setDisplayPageBreaks

public void setDisplayPageBreaks(boolean value)

getComments

public Comments getComments()

getHyperlinks

public Hyperlinks getHyperlinks()

clearCircles

public void clearCircles()

circleInvalid

public void circleInvalid()

getAutoFilter

public AutoFilter getAutoFilter()

isDisplayRightToLeft

public boolean isDisplayRightToLeft()

setDisplayRightToLeft

public void setDisplayRightToLeft(boolean value)

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()

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)

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,
                   TextVisualLayoutType textVisualLayout)

getCustomProperties

public CustomProperties getCustomProperties()

getSmartTags

public SmartTags getSmartTags()

getProtection

public Protection getProtection()

pasteSpecial

public void pasteSpecial()

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link,
                         boolean displayAsIcon)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link,
                         boolean displayAsIcon,
                         java.lang.String iconFileName)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link,
                         boolean displayAsIcon,
                         java.lang.String iconFileName,
                         int iconIndex)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link,
                         boolean displayAsIcon,
                         java.lang.String iconFileName,
                         int iconIndex,
                         java.lang.String iconLabel)

pasteSpecial

public void pasteSpecial(java.lang.String clipboardFormat,
                         boolean link,
                         boolean displayAsIcon,
                         java.lang.String iconFileName,
                         int iconIndex,
                         java.lang.String iconLabel,
                         boolean noHTMLFormatting)

protect

public void protect()

protect

public void protect(java.lang.String password)

getListObjects

public ListObjects getListObjects()

xmlDataQuery

public Range xmlDataQuery(java.lang.String xPath)

xmlDataQuery

public Range xmlDataQuery(java.lang.String xPath,
                          java.lang.String selectionNamespaces)

xmlDataQuery

public Range xmlDataQuery(java.lang.String xPath,
                          java.lang.String selectionNamespaces,
                          XmlMap map)

xmlMapQuery

public Range xmlMapQuery(java.lang.String xPath)

xmlMapQuery

public Range xmlMapQuery(java.lang.String xPath,
                         java.lang.String selectionNamespaces)

xmlMapQuery

public Range xmlMapQuery(java.lang.String xPath,
                         java.lang.String selectionNamespaces,
                         XmlMap map)