[ TAG 706 ][25.02.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste

-
Ich setze die meine Einarbeitung in Google Apps Script fort. Für heute habe ich mir geplant mich in Objekte einzuarbeiten, die mit der Verwaltung der Tabellen zu tun haben. Es sind natürlich viele Objekte, jedoch muss ich aus zeitlichen Gründen nur für die wichtigsten entscheiden.

BLKBRD-Referenzen:
[ Sheet-Objekt ]
[ ext_prj_2023 > BLKBRD-23-0 > 20230226_155311.jpg ]

Hier sind ein paar nützliche Videobeiträge:
  • [ YouTube-Kanal: Learn Google Sheets & Excel Spreadsheets ]
    • [ https://www.youtube.com/@ExcelGoogleSheets/playlists ]
  • [ Playlist: App Script Editor Tutorial - Google Sheets ]
    • [ https://www.youtube.com/watch?v=aPJ-2U45BpA&list=PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw ]
  • [Google Sheets und Docs automatiseren (Google APPS SCRIPT Tutorial)]
    • [ https://www.youtube.com/watch?v=9QMsdZ30GjA ]

  • [ SpreadsheetApp ]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#properties ]
  • [ create(name) ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#create(String) ]
  • [ create(name, rows, columns) ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#create(String,Integer,Integer) ]
  • [ flush() ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#flush() ]
  • [ getActive() ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getActive() ]
  • [ getActiveRange() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getActiveRange() ]
  • [ getActiveRangeList() ] - RangeList
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getActiveRangeList() ]
  • [ getActiveSheet() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getActiveSheet() ]
  • [ getActiveSpreadsheet() ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getActiveSpreadsheet() ]
  • [ getCurrentCell() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getCurrentCell() ]
  • [ getSelection() ] - Selection
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getSelection() ]
  • [ getUi() ] - Ui
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#getUi() ]
  • [ newTextStyle() ] - TextStyleBuilder
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#newTextStyle() ]
  • [ open(file) ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#open(File) ]
  • [ openById(id) ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#openById(String) ]
  • [ openByUrl(url) ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#openByUrl(String) ]
  • [ setActiveRange(range) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setActiveRange(Range) ]
  • [ setActiveRangeList(rangeList) ] - RangeList
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setActiveRangeList(RangeList) ]
  • [ setActiveSheet(sheet) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setActiveSheet(Sheet) ]
  • [ setActiveSheet(sheet, restoreSelection) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setActiveSheet(Sheet,Boolean) ]
  • [ setActiveSpreadsheet(newActiveSpreadsheet) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setActiveSpreadsheet(Spreadsheet) ]
  • [ setCurrentCell(cell) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#setCurrentCell(Range) ]

  • [ Sheet ]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de ]
  • [ activate() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#activate() ]
  • [ appendRow(rowContents) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#appendRow(Object) ]
  • [ autoResizeColumn(columnPosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#autoResizeColumn(Integer) ]
  • [ autoResizeColumns(startColumn, numColumns) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#autoResizeColumns(Integer,Integer) ]
  • [ autoResizeRows(startRow, numRows) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#autoResizeRows(Integer,Integer) ]
  • [ ]
  • [ clear() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clear() ]
  • [ clear(options) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clear(Object) ]
  • [ clearConditionalFormatRules() ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clearConditionalFormatRules() ]
  • [ clearContens() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clearContents() ]
  • [ clearFormats() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clearFormats() ]
  • [ clearNotes() ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#clearNotes() ]
  • [ copyTo(spreadsheet) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#copyTo(Spreadsheet) ]
  • [  ]
  • [ deleteColumn(columnPosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#deleteColumn(Integer) ]
  • [ deleteColumns(columnPosition, howMany) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#deleteColumns(Integer,Integer) ]
  • [ deleteRow(rowPosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#deleteRow(Integer) ]
  • [ deleteRows(rowPosition, howMany) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#deleteRows(Integer,Integer) ]
  • [ getActiveCell() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getActiveCell() ]
  • [ getActiveRange() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getActiveRange() ]
  • [ getActiveRangeList() ] - RangeList
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getActiveRangeList() ]
  • [ getColumnWidth(columnPosition) ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getColumnWidth(Integer) ]
  • [ getCurrentCell() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getCurrentCell() ]
  • [ getDataRange() ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getDataRange() ]
  • [ getIndex() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getIndex() ]
  • [ getLastColumn() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getLastColumn() ]
  • [ getLastRow() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getLastRow() ]
  • [ getMaxColumns() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getMaxColumns() ]
  • [ getMaxRows() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getMaxRows() ]
  • [ getName() ] - String
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getName() ]
  • [ getNamedRanges() ] - NamedRanges[]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getNamedRanges() ]
  • [ getParent() ] - Spreadsheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getParent() ]
  • [ getRange(row, column) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getRange(Integer,Integer) ]
  • [ getRange(row, column, numRows) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getRange(Integer,Integer,Integer) ]
  • [ getRange(row, column, numRows, numColumns) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getRange(Integer,Integer,Integer,Integer) ]
  • [ getRange(a1Notation) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getRange(String) ]
  • [ getRangeList(a1Notations) ] - RangeList
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getRangeList(String) ]
  • [ getSelection() ] - Selection
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getSelection() ]
  • [ getSheetId() ] - Integer
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getSheetId() ]
  • [ getSheetName() ] - String
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getSheetName() ]
  • [ getSheetValues(startRow, startColumn, numRows, numColumns) ] - Object[][]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getSheetValues(Integer,Integer,Integer,Integer) ]
  • [ getType() ] - SheetType
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#getType() ]
  • [ insertColumnAfter(afterPosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertColumnAfter(Integer) ]
  • [ insertColumnBefore(beforePosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertColumnBefore(Integer) ]
  • [ insertColumns(columnIndex, numColumns) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertColumns(Integer,Integer) ]
  • [ insertColumnsAfter(afterPosition, howMany) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertColumnsAfter(Integer,Integer) ]
  • [ insertColumnsBefore(beforePosition, howMany) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertColumnsBefore(Integer,Integer) ]
  • [ insertRowAfter(afterPosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRowAfter(Integer) ]
  • [ insertRowBefore(beforePosition) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRowBefore(Integer) ]
  • [ insertRows(rowIndex) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRows(Integer) ]
  • [ insertRows(rowIndex, numRows) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRows(Integer,Integer) ]
  • [ insertRowsAfter(afterPosition, howMany) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRowsAfter(Integer,Integer) ]
  • [ insertRowBefore(beforePosition, howMany) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#insertRowsBefore(Integer,Integer) ]
  • [ moveColumns(columnSpec, destinationIndex) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#moveColumns(Range,Integer) ]
  • [ moveRows(rowSpec, destinationIndex) ] - void
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#moveRows(Range,Integer) ]
  • [ setActiveRange(range) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setActiveRange(Range) ]
  • [ setActiveRangeList(rangeList) ] - RangeList
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setActiveRangeList(RangeList) ]
  • [ setActiveSelection(range) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setActiveSelection(Range) ]
  • [ setActiveSelection(a1Notation) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setActiveSelection(String) ]
  • [ setColumnWidth(columnPosition, width) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setColumnWidth(Integer,Integer) ]
  • [ setColumnWidths(startColumn, numColumns, width) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setColumnWidths(Integer,Integer,Integer) ]
  • [ setCurrentCell(cell) ] - Range
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setCurrentCell(Range) ]
  • [ setName(name) ] - Sheet
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de#setName(String) ]


  • [ Range ]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de ]


 

Kommentare

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

[ TAG 38 ][29.05.2021] - Erfolgreich - Freelancer-Portale

-
 Ich habe mich heute in der Freelancer-Gemeinde umgeschaut. Dabei habe ich folgende Seiten gefunden. https://de.fiverr.com/ https://www.freelance.de/ https://www.freelancer.de/ https://www.freelancermap.de/ https://www.twago.de/ Einige weitere interessante Punkte sind hier aufgelistet. https://www.fuer-gruender.de/wissen/unternehmen-gruenden/unternehmensformen/freelancer/ Dieses Video hat mich für die kurze Recherche inspiriert. Ich muss mich heute in Python einarbeiten. Mal schauen ob ich es schaffe. https://www.youtube.com/watch?v=eqrKxDbzhbg Ich denke es ist eine interessante Möglichkeit seiner Beschäftigung nachzugehen und zugleich auch die Familienkasse zu verbessern.
Mehr anzeigen

[ TAG 747 ][07.04.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste

-
Ein wichtiger Baustein im WebDev sind die Asynchronen Sprachkomponente von JavaScript. [ Don't Imitate, Understand #2 - Promises, Async, and Await ] [ https://www.youtube.com/watch?v=fyGSyqEX2dw ] [ Async JavaScript & Callback Functions -- Tutorial for Beginners ] [ https://www.youtube.com/watch?v=QSqc6MMS6Fk ] [ JavaScript Promises -- Tutorial for Beginners ] [ https://www.youtube.com/watch?v=TnhCX0KkPqs ] [ Async Await vs. Promises - JavaScript Tutorial for beginners ] [ https://www.youtube.com/watch?v=spvYqO_Kp9Q ] [ Fetch API - JavaScript Tutorial for beginners ] [ https://www.youtube.com/watch?v=ubw2hdQIl4E ] Sonstiges [ Arduino MASTERCLASS | Full Programming Workshop in 90 Minutes! ] [ https://www.youtube.com/watch?v=BLrHTHUjPuw ] [ Google Sheets - Userform ] [ https://www.youtube.com/watch?v=PsIuSwSj3CM ] [ Google Sheets - Email HTML Tables & Schedule Apps Scripts ] [ https://www.youtube.com/watch?...
Mehr anzeigen

[ TAG 52 ][12.06.2021] - Erfolgreich - IAP-20210601-20210609-2325

-
Bild
 Ich beginne mit der Programmierung am [ IAP-20210601-20210609-2325 ]. Ich habe gerade überprüft ob [ numpy ] installiert ist. Dies ist nicht der fall. Beim [ IAP-20210601-20210605-0404 ] habe ich nur [ python-sounddevice ][ Quelle ] installiert. Bei der Installation des [ python-sounddevice ] wird scheinbar die [ numpy ] mit installiert. Ich werde es jetzt als erstes testen. Eine gute Quelle für die Einarbeitung in Python:  https://www.programiz.com/python-programming/first-program Installation Quelle:  https://python-sounddevice.readthedocs.io/en/0.4.1/installation.html Installationsbefehl: [ conda install -c conda-forge python-sounddevice ] Bei der Installation wird [ numpy ] mit installiert TEST - [ numpy ] - Array Ich habe [ sounddevice ] installiert und teste jetzt numpy-Array numpy-Array anlegen Rahmenbedingungen duration = 2 AUFNAHMEZEIT = 2 SEKUNDEN fs = 44100 SAMPLERATEN = 44.100 Hz FRAMES pro SEKUNDE DATENAUFNAHMEN pro SEKUNDE frms = int(duration * fs) GES...
Mehr anzeigen