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();
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`DataTableSource` is an interface for objects that can present their data as a `DataTable` for use in Google Charts."],["Classes such as `DataTable` and `Range` implement the `DataTableSource` interface."],["The primary method of `DataTableSource` is `getDataTable()`, which returns the object's data formatted as a `DataTable`."],["You can access data from spreadsheet ranges and use it to create charts using the `DataTableSource` and the Charts service."]]],["The `DataTableSource` interface allows objects to represent data as a `DataTable`. It includes the `getDataTable()` method, which returns the object's data in `DataTable` format. Classes like `DataTable` and `Range` implement this interface. The provided example demonstrates retrieving a `Range` from a spreadsheet, converting it to a `DataTable` using `getDataTable()`, and then utilizing this data to construct a bar chart with the Charts service.\n"]]
