setSheetTopMargin

Set the print top margin. Applies to the currently active sheet by default.

setSheetTopMargin( workbook, marginSize[, sheetName[, sheetNumber] ] )

Required arguments

• workbook spreadsheet object
• marginSize numeric: size in inches

Optional arguments

• sheetName string: the name of the sheet to apply the orientation mode to OR
• sheetNumber numeric: the number (1 based, not zero-based) of the sheet to apply the orientation mode to

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.createSheet( workbook, "test" );
spreadsheet.setSheetTopMargin( workbook, 1.5 );