[ TAG 705 ][24.02.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste

-
Bei diesen Beitrag werde ich mich heute in Google Codes einarbeiten. Als erstes erstelle ich eine Liste von Objekten und deren Methoden mit denen man in Zukunft arbeiten muss.

Vorher gebe ich einige wichtige YouTube-Beiträge, die für die Einarbeitung sehr nützlich sind.
  • [ 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 ]

Ich beginne mit dem Objekt DriveApp.
  • [ DriveApp ]
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de ]
  • [ createFile(blob) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#createFile(BlobSource) ]
  • [ createFile(name, content) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#createFile(String,String) ]
  • [ createFile(name, content, mimeType) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#createFile(String,String,String) ]
  • [ createFolder(name) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#createFolder(String) ]
  • [ getFileById(id) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFileById(String) ]
  • [ getFileByIdAndResourceKey(id, resourceKey) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFileByIdAndResourceKey(String,String) ]
  • [ getFiles() ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFiles() ]
  • [ getFilesByName(name) ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFilesByName(String) ]
  • [ getFilesByType(mimeType) ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFilesByType(String) ]
  • [ getFolderById(id) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFolderById(String) ]
  • [ getFolderByIdAndResourceKey(id, resourceKey) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFolderByIdAndResourceKey(String,String) ]
  • [ getFolders() ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFolders() ]
  • [ getFoldersByName(name) ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getFoldersByName(String) ]
  • [ getRootFolder() ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de#getRootFolder() ]

  • [ FolderIterator ]
    • [ https://developers.google.com/apps-script/reference/drive/folder-iterator?hl=de ]
  • [ hasNext() ] - Boolean
    • [ https://developers.google.com/apps-script/reference/drive/folder-iterator?hl=de#hasNext() ]
  • [ next() ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder-iterator?hl=de#next() ]




  • [ Folder ]
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de ]
  • [ createFile(blob) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#createFile(BlobSource) ]
  • [ createFile(name, content) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#createFile(String,String) ]
  • [ createFile(name, content, mimeType) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#createFile(String,String,String) ]
  • [ createFolder(name) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#createFolder(String) ]
  • [ getDateCreated() ] - Date
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getDateCreated() ]
  • [ getDescription() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getDescription() ]
  • [ getFiles() ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getFiles() ]
  • [ getFilesByName(name) ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getFilesByName(String) ]
  • [ getFilesByType(mimeType) ] - FileIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getFilesByType(String) ]
  • [ getFolders() ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getFolders() ]
  • [ getFoldersByName(name) ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getFoldersByName(String) ]
  • [ getId() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getId() ]
  • [ getName() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getName() ]
  • [ getParents() ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getParents() ]
  • [ getResourceKey() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getResourceKey() ]
  • [ getSize() ] - Integer
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getSize() ]
  • [ getUrl() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#getUrl() ]
  • [  ]
  • [ moveTo(destination) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#moveTo(Folder) ]
  • [ ]
  • [ setDescription(description) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#setDescription(String) ]
  • [ setName(name) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#setName(String) ]
  • []
  • [ setTrashed(trashed) ] - Folder
    • [ https://developers.google.com/apps-script/reference/drive/folder?hl=de#setTrashed(Boolean) ]

  • [ File ]
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de ]
  • [ getAs(contentType) ] - Blob
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getAs(String) ]
  • [ getDateCreated() ] - Date
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getDateCreated() ]
  • [ getDescription() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getDescription() ]
  • [ getDownloadUrl() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getDownloadUrl() ]
  • [ getId() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getId() ]
  • [ getMimeType() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getMimeType() ]
  • [ getName() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getName() ]
  • [ getParents() ] - FolderIterator
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getParents() ]
  • [ getResourceKey() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getResourceKey() ]
  • [ getSize() ] - Integer
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getSize() ]
  • [ getTargetId() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getTargetId() ]
  • [ getTargetMimeType() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getTargetMimeType() ]
  • [ getTargetResourceKey() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getTargetResourceKey() ]
  • [ getUrl() ] - String
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#getUrl() ]
  • [ makeCopy() ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#makeCopy() ]
  • [ makeCopy(destination) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#makeCopy(Folder) ]
  • [ makeCopy(name) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#makeCopy(String) ]
  • [ makeCopy(name, destination) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#makeCopy(String,Folder) ]
  • [ moveTo(destination) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#moveTo(Folder) ]
  • [  ]
  • [ setContent(content) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#setContent(String) ]
  • [ setDescription(description) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#setDescription(String) ]
  • [ setName(name) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#setName(String) ]
  • [ setTrashed(trashed) ] - File
    • [ https://developers.google.com/apps-script/reference/drive/file?hl=de#setTrashed(Boolean) ]
Diese Methoden müssen morgen erarbeitet werden.
  • [ SpreadsheetApp ]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de#properties ]
  • [ Sheet ]
    • [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de ]
  • [ 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