Accessor methods
findEntireSheetRange method
findRangeFromCoordinates method
findRangeFromString method
Getting Range Information
getEndColumn method
getEndRow method
getStartColumn method
getStartRow method
toString method
Sheet Properties
AdornmentsVisible property
BackgroundImageName property
CellProtection property
ColumnHeadingsVisible property
DefaultAlignment property
DefaultBackgroundColor property
DefaultColumnWidth property
DefaultNumberFormat property
DefaultNumberFormatDecimal property
DefaultRowHeight property
DefaultTextColor property
DefaultTextFont property
DefaultTextFontName property
DefaultTextSize property
EditLineVisible property
FrameColor property
GridLinesVisible property
HorizontalScrollBarVisible property
RecalcManual property
RowHeadingsVisible property
StatusLineVisible property
VerticalScrollBarVisible property
File Input and Output
getDocumentName method
newDocument method
openDocument method
openDocumentFromStream method
saveDocument method
saveDocumentToStream method
Setting and Getting Cell Contents
getCellContents method
getCellValueAsNumber method
getCellValueAsString method
isEmptyCell method
isERRCell method
isFormulaCell method
isNACell method
isNumberCell method
isStringCell method
setCellContentsFromNumber method
setCellContentsFromString method
Range Properties
Alignment property
BackgroundColor property
Border property
ColumnHidden property
ColumnWidth property
NumberFormat property
RowHeight property
RowHidden property
TextBold property
TextColor property
TextFont property
TextFontName property
TextItalic property
TextSize property
Named Ranges
createRangeName method
deleteRangeName method
Sheet Commands
deleteColumns method
clear method
copy method
cut method
deleteRows method
insertColumns method
insertRows method
paste method
sort method
Navigating and Selecting
scrollTo method
Selection property
Page Breaks
HorizontalPageBreak property
VerticalPageBreak property
Printing Sheets
print method
printRange method
Cell Protection
Protection property
Calculating Formulas
calc method