Interface DataTableSource

資料表格來源

可將資料表示為 DataTable 的物件介面。

實作類別

名稱簡短說明
DataTable用於圖表的資料表。
Range存取及修改試算表區間。

方法

方法傳回類型簡短說明
getDataTable()DataTable將這個物件內的資料以 DataTable 的形式傳回。

內容詳盡的說明文件

getDataTable()

將這個物件內的資料做為 DataTable 傳回。

// Opens the spreadsheet file by its ID. If you created your script from a
// Google Sheets file, use SpreadsheetApp.getActiveSpreadsheet().
// TODO(developer): Replace the ID with your own.
const ss = SpreadsheetApp.openById('abc123456');

// Gets Sheet1 by its name.
const sheet = ss.getSheetByName('Sheet1');

// Gets the range A1:B7 on Sheet1.
const range = sheet.getRange('A1:B7');

// Gets the range A1:B7 as a data table. The values in each column must be of
// the same type.
const datatable = range.getDataTable();

// Uses the Charts service to build a bar chart from the data table.
// This doesn't build an embedded chart. To do that, use
// sheet.newChart().addRange() instead.
const chart = Charts.newBarChart()
                  .setDataTable(datatable)
                  .setOption('title', 'Your Chart Title Here')
                  .build();

回攻員

DataTable：資料為資料表格。