Interface DataTableSource
Page Summary
DataTableSource is an interface for objects that can represent their data as a DataTable.
Implementing classes include DataTable and Range, which can be used with DataTableSource.
The
getDataTable()method returns the data within an object as a DataTable.The provided example demonstrates how to use
getDataTable()with a Range to create a chart.
Interface for objects that can represent their data as aData.
Implementing classes
Methods
| Method | Return type | Brief description |
|---|---|---|
get | Data | Return the data inside this object as a DataTable. |
Detailed documentation
getDataTable()
Return the data inside this object as a 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.constss=SpreadsheetApp.openById('abc123456');// Gets Sheet1 by its name.constsheet=ss.getSheetByName('Sheet1');// Gets the range A1:B7 on Sheet1.constrange=sheet.getRange('A1:B7');// Gets the range A1:B7 as a data table. The values in each column must be of// the same type.constdatatable=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.constchart=Charts.newBarChart().setDataTable(datatable).setOption('title','Your Chart Title Here').build();
Return
Data — the data as a datatable.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-11 UTC.