ochilab

Set objWShell = CreateObject("Wscript.Shell") 
objWShell.run "cmd /c xxxxx.bat", vbHide 

ochilab

def OJEncoder(obj):
    class MyEncoder(JSONEncoder):
        def default(self, o):
            return o.__dict__ 
    return MyEncoder(ensure_ascii=False).encode(obj)   

ochilab

# -*- coding: utf-8 -*-

# use tiffile library
# https://pypi.org/project/tifffile/

import pyrealsense2 as rs
import numpy as np
import tifffile

ochilab

var selection = DocumentApp.getActiveDocument().getSelection();
if (selection) {
  var elements = selection.getRangeElements();
  text= elements[0].getElement().asText().getText();
  text = text.substring(elements[0].getStartOffset(),elements[0].getEndOffsetInclusive());
  DocumentApp.getUi().alert(text);
} 

ochilab

import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore
import os

#環境変数
os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = './firebasekey.json'
cred = credentials.Certificate('firebasekey.json')
firebase_admin.initialize_app(cred)
db = firestore.Client()

ochilab

function downloadFile() {
 var content="aaaa,bbbbb,ccccc";
 var blob = new Blob([ content ], { "type" : "text/csv"});
 var downLoadLink = document.createElement("a");
 downLoadLink.download ="test.csv";
 downLoadLink.href =  window.URL.createObjectURL(blob);
 downLoadLink.dataset.downloadurl = ["text/plain", downLoadLink.download, downLoadLink.href].join(":");
 downLoadLink.click();
}

ochilab

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">

ochilab

function assignScriptToImage() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var images =sheet.getImages();
  images[0].assignScript("test");
}
function test(){
  Browser.msgBox("aaa");
}

ochilab

function getClassList(){
  var optionalArgs = {
    pageSize: 100  //クラスの数が多い場合はここを増やす
  };  
  var response = Classroom.Courses.list(optionalArgs);
  var courses = response.courses;
  if (courses && courses.length > 0) {
    for (i in courses) {
      var course = courses[i];
      Logger.log(course.name); 

ochilab

import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore
import os

#環境変数
os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = './xxxxx-credentials.json'

#credentialsの読み込み
cred = credentials.Certificate('xxxxx-credentials.json')