setSheetTopMargin - cfsimplicity/spreadsheet-cfml GitHub Wiki

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