Google App Script 應用

google app script 應用於 Google 試算表透過試算表做簡易資料庫

參考官方文件

第一步建立google試算表並開啟與他人共用

第二步安裝 google app script

安裝完後點選 google app script new 一個新專案
直接放上讀取表單程式碼

function doGet(e) {
  var params = e.parameter;
  var sheetUrl = params.sheetUrl;
  var sheetTag = params.sheetTag;
  var row = params.row;
  var col = params.col;
  var endRow = params.endRow;
  var endCol = params.endCol;
  var rowRange = endRow - row + 1;
  var colRange = endCol - col + 1;

  var SpreadSheet = SpreadsheetApp.openByUrl(sheetUrl);
  var Sheet = SpreadSheet.getSheetByName(sheetTag);

  var lastRow = Sheet.getLastRow();
  var lastCol = Sheet.getLastColumn();

  if(rowRange>lastRow){
    rowRange = lastRow;
  }

  if(colRange>lastCol){
    colRange = lastCol;
  }

  var data = Sheet.getSheetValues(row, col, rowRange,colRange);

  return ContentService.createTextOutput(data);
}