Skip to content
Julian Halliwell edited this page Sep 20, 2021 · 2 revisions

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

setSheetLeftMargin( 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.setSheetLeftMargin( workbook, 1.5 );
Clone this wiki locally