Sheet API Index



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