Function writeToSheet

Parameters

• sheetName: string

  Name of sheet where array should be written. If it does not exist, it is created.

• writeArray: any[][]

  Rectangular 2D array containing data to be written

• __namedParameters: {
      clearSheet?: boolean;
      mode?: "OVERWRITE" | "APPENDROWS" | "APPENDCOLUMNS";
      ss?: Spreadsheet;
      startColumn?: number;
      startRow?: number;
      templateSheetName?: string;
  } = {}

  • Optional clearSheet?: boolean

  • Optional mode?: "OVERWRITE" | "APPENDROWS" | "APPENDCOLUMNS"

  • Optional ss?: Spreadsheet

  • Optional startColumn?: number

  • Optional startRow?: number

  • Optional templateSheetName?: string