[ TAG 786 ][16.05.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste

-
Ich beginne meine Worksession um [16.05.2023][0350]. 
Die Liste vom [ TAG 784 ][14.05.2023] wird weitergeführt.

  • [Range]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de]
  • [ getSheet() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getSheet()]
Anzahl der ausgewählten Zeilen und Spalten in Range
  • [ getWidth() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getWidth()]
  • [ getHeight() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getHeight()]
  • [ getNumColumns() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNumColumns()]
  • [ getNumRows() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNumRows()]
  • [ getLastColumn() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getLastColumn()]
  • [ getLastRow() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getLastRow()]
Range-Koordinaten
  • [ getA1Notation() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getA1Notation()]
  • [ getCell(row, column) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getCell(Integer,Integer)]
  • [ getColumn() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getColumn()]
  • [ getRow() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getRow()]
  • [ getRowIndex() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getRowIndex()]
Zellen-Werte auslesen
  • [ getDisplayValue() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getDisplayValue()]
  • [ getDisplayValues() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getDisplayValues()]
  • [ getValue() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getValue()]
  • [ getValues() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getValues()]
Gruppen
  • [ collapseGroups() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#collapseGroups()]
  • [ expandGroups() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#expandGroups()]
  • [ shiftColumnGroupDepth(delta) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#shiftColumnGroupDepth(Integer)]
  • [ shiftRowGroupDepth(delta) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#shiftRowGroupDepth(Integer)]
Clear-Operationen
  • [ clear() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clear()]
  • [ clear(options) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clear(Object)]
  • [ clearContent() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clearContent()]
  • [ clearDataValidations() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clearDataValidations()]
  • [ clearFormat() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clearFormat()]
  • [ clearNote() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#clearNote()]

Getter
  • [ getBackground() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getBackground()]
  • [ getBackgroundObject() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getBackgroundObject()]
  • [ getBackgroundObjects() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getBackgroundObjects()]
  • [ getBackgrounds() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getBackgrounds()]
  • --------------------------------------------------------
  • [ getFontColorObject() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontColorObject()]
  • [ getFontColorObjects() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontColorObjects()]
  • --------------------------------------------------------
  • [ getFontFamilies() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontFamilies()]
  • [ getFontFamily() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontFamily()]
  • --------------------------------------------------------
  • [ getFontLine() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontLine()]
  • [ getFontLines() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontLines()]
  • --------------------------------------------------------
  • [ getFontSize() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontSize()]
  • [ getFontSizes() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontSizes()]
  • --------------------------------------------------------
  • [ getFontStyle() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontStyle()]
  • [ getFontStyles() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontStyles()]
  • [ getFontWeight() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontWeight()]
  • [ getFontWeights() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFontWeights()]
  • --------------------------------------------------------
  • [ getFormula() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFormula()]
  • [ getFormulaR1C1() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFormulaR1C1()]
  • [ getFormulas() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFormulas()]
  • [ getFormulasR1C1() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getFormulasR1C1()]
  • --------------------------------------------------------
  • [ getHorizontalAlignment() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getHorizontalAlignment()]
  • [ getHorizontalAlignments() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getHorizontalAlignments()]
  • --------------------------------------------------------
  • [ getNote() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNote()]
  • [ getNotes() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNotes()]
  • --------------------------------------------------------
  • [ getNumberFormat() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNumberFormat()]
  • [ getNumberFormats() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getNumberFormats()]
  • --------------------------------------------------------
  • [ getRichTextValue() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getRichTextValue()]
  • [ getRichTextValues() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getRichTextValues()]
  • --------------------------------------------------------
  • [ getTextStyle() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getTextStyle()]
  • [ getTextStyles() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getTextStyles()]
  • --------------------------------------------------------
  • [ getValue() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getValue()]
  • [ getValues() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getValues()]
  • --------------------------------------------------------
  • [ getWrap() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getWrap()]
  • [ getWrapStrategies() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getWrapStrategies()]
  • [ getWrapStrategy() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getWrapStrategy()]
  • [ getWraps() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#getWraps()]

Setter
  • [ setBackground(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setBackground(String)]
  • [ setBackgroundObject(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setBackgroundObject(Color)]
  • [ setBackgroundObjects(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setBackgroundObjects(Color)]
  • [ setBackgroundRGB(red, green, blue) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setBackgroundRGB(Integer,Integer,Integer)]
  • [ setBackgrounds(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setBackgrounds(String)]
  • --------------------------------------------------------
  • [ setBorder() ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setbordertop,-left,-bottom,-right,-vertical,-horizontal,-color,-style]
  • [ BorderStyle ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/border-style?hl=de]
  • --------------------------------------------------------
  • [ setFontColor(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontColor(String)]
  • [ setFontColorObject(color) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontColorObject(Color)]
  • [ setFontColorObjects(colors) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontColorObjects(Color)]
  • [ setFontColors(colors) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontColors(Object)]
  • --------------------------------------------------------
  • [ setFontFamilies(fontFamilies) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontFamilies(Object)]
  • [ setFontFamily(fontFamily) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontFamily(String)]
  • --------------------------------------------------------
  • [ setFontLine(fontLine) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontLine(String)]
  • [ setFontLines(fontLines) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontLines(Object)]
  • --------------------------------------------------------
  • [ setFontSize(size) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontSize(Integer)]
  • [ setFontSizes(sizes) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontSizes(Object)]
  • --------------------------------------------------------
  • [ setFontStyle(fontStyle) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontStyle(String)]
  • [ setFontStyles(fontStyles) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontStyles(Object)]
  • --------------------------------------------------------
  • [ setFontWeight(fontWeight) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontWeight(String)]
  • [ setFontWeights(fontWeights) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFontWeights(Object)]
  • --------------------------------------------------------
  • [ setFormula(formula) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFormula(String)]
  • [ setFormulaR1C1(formula) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFormulaR1C1(String)]
  • [ setFormulas(formulas) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFormulas(String)]
  • [ setFormulasR1C1(formulas) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setFormulasR1C1(String)]
  • --------------------------------------------------------
  • [ setHorizontalAlignment(alignment) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setHorizontalAlignment(String)]
  • [ setHorizontalAlignments(alignments) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setHorizontalAlignments(Object)]
  • --------------------------------------------------------
  • [ setNote(note) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setNote(String)]
  • [ setNotes(notes) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setNotes(Object)]
  • --------------------------------------------------------
  • [ setNumberFormat(numberFormat) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setNumberFormat(String)]
  • [ setNumberFormats(numberFormats) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setNumberFormats(Object)]
  • [Datums- und Zahlenformate]
    • [https://developers.google.com/sheets/api/guides/formats?hl=de]
  • --------------------------------------------------------
  • [ setRichTextValue(value) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setRichTextValue(RichTextValue)]
  • [ setRichTextValues(values) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setRichTextValues(RichTextValue)]
  • [ Class RichTextValue ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/rich-text-value?hl=de]
  • --------------------------------------------------------
  • [ setTextStyle(style) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setTextStyle(TextStyle)]
  • [ setTextStyles(styles) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setTextStyles(TextStyle)]
  • [ Class TextStyle ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/text-style?hl=de]
  • --------------------------------------------------------
  • [ setValue(value) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setValue(Object)]
  • [ setValues(values) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setValues(Object)]
  • --------------------------------------------------------
  • [ setWrap(isWrapEnabled) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setWrap(Boolean)]
  • [ setWrapStrategies(strategies) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setWrapStrategies(WrapStrategy)]
  • [ setWrapStrategy(strategy) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setWrapStrategy(WrapStrategy)]
  • [ setWraps(isWrapEnabled) ]
    • [https://developers.google.com/apps-script/reference/spreadsheet/range?hl=de#setWraps(Object)]










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