Interface DataTableSource
Stay organized with collections
Save and categorize content based on your preferences.
Spark icon
AI-generated Key Takeaways
-
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.
DataTableSource
Interface for objects that can represent their data as a Data.
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.