// 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();
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["필요한 정보가 없음","missingTheInformationINeed","thumb-down"],["너무 복잡함/단계 수가 너무 많음","tooComplicatedTooManySteps","thumb-down"],["오래됨","outOfDate","thumb-down"],["번역 문제","translationIssue","thumb-down"],["샘플/코드 문제","samplesCodeIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-07-26(UTC)"],[[["\u003cp\u003e\u003ccode\u003eDataTableSource\u003c/code\u003e is an interface for objects that can present their data as a \u003ccode\u003eDataTable\u003c/code\u003e for use in Google Charts.\u003c/p\u003e\n"],["\u003cp\u003eClasses such as \u003ccode\u003eDataTable\u003c/code\u003e and \u003ccode\u003eRange\u003c/code\u003e implement the \u003ccode\u003eDataTableSource\u003c/code\u003e interface.\u003c/p\u003e\n"],["\u003cp\u003eThe primary method of \u003ccode\u003eDataTableSource\u003c/code\u003e is \u003ccode\u003egetDataTable()\u003c/code\u003e, which returns the object's data formatted as a \u003ccode\u003eDataTable\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eYou can access data from spreadsheet ranges and use it to create charts using the \u003ccode\u003eDataTableSource\u003c/code\u003e and the Charts service.\u003c/p\u003e\n"]]],["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"],null,["# Interface DataTableSource\n\nDataTableSource\n\nInterface for objects that can represent their data as a [DataTable](/apps-script/reference/charts/data-table).\n\n### Implementing classes\n\n| Name | Brief description |\n|-------------------------------------------------------|---------------------------------------|\n| [DataTable](/apps-script/reference/charts/data-table) | A Data Table to be used in charts. |\n| [Range](../spreadsheet/range.html) | Access and modify spreadsheet ranges. |\n\n### Methods\n\n| Method | Return type | Brief description |\n|-----------------------------------|-------------------------------------------------------|----------------------------------------------------|\n| [getDataTable()](#getDataTable()) | [DataTable](/apps-script/reference/charts/data-table) | Return the data inside this object as a DataTable. |\n\nDetailed documentation\n----------------------\n\n### `get``Data``Table()`\n\nReturn the data inside this object as a DataTable.\n\n```javascript\n// Opens the spreadsheet file by its ID. If you created your script from a\n// Google Sheets file, use SpreadsheetApp.getActiveSpreadsheet().\n// TODO(developer): Replace the ID with your own.\nconst ss = SpreadsheetApp.openById('abc123456');\n\n// Gets Sheet1 by its name.\nconst sheet = ss.getSheetByName('Sheet1');\n\n// Gets the range A1:B7 on Sheet1.\nconst range = sheet.getRange('A1:B7');\n\n// Gets the range A1:B7 as a data table. The values in each column must be of\n// the same type.\nconst datatable = range.getDataTable();\n\n// Uses the Charts service to build a bar chart from the data table.\n// This doesn't build an embedded chart. To do that, use\n// sheet.newChart().addRange() instead.\nconst chart = Charts.newBarChart()\n .setDataTable(datatable)\n .setOption('title', 'Your Chart Title Here')\n .build();\n```\n\n#### Return\n\n\n[DataTable](/apps-script/reference/charts/data-table) --- the data as a datatable."]]
