Class DataTableBuilder
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
DataTableBuilder
DataTable 对象的构建器。构建数据表的过程包括:先指定其列,然后逐一添加其行。示例:
const data = Charts.newDataTable()
.addColumn(Charts.ColumnType.STRING, 'Month')
.addColumn(Charts.ColumnType.NUMBER, 'In Store')
.addColumn(Charts.ColumnType.NUMBER, 'Online')
.addRow(['January', 10, 1])
.addRow(['February', 12, 1])
.addRow(['March', 20, 2])
.addRow(['April', 25, 3])
.addRow(['May', 30, 4])
.build();
详细文档
addColumn(type, label)
向数据表格添加列。添加的列编号为 0 到 n。
图表通常会将第一列用作标签(例如,线图上的 X 轴标签或饼图中的切片标签)。其他列通常用于存储数据,因此通常需要数字值。
参数
名称 | 类型 | 说明 |
type | ColumnType | 列中数据的类型(数字、字符串或日期) |
label | String | 列的标签(用于图表图例)。 |
返回
DataTableBuilder
- this 构建器,用于链式调用。
addRow(values)
向数据表中添加一行。
参数
名称 | 类型 | 说明 |
values | Object[] | 行对应的值,按照输入列的顺序指定。 |
返回
DataTableBuilder
- this 构建器,用于链式调用。
setValue(row, column, value)
在表中设置特定值。
您可以在将列添加到数据表之前设置值。不过,除非您在某个时间点添加该列,否则系统会忽略该值。
并非所有列值都需要填写。缺失的值将被视为 null
。
参数
名称 | 类型 | 说明 |
row | Integer | 行索引(第一行索引为 0) |
column | Integer | 列索引(第一列的索引为 0) |
value | Object | 表格单元格的值(应为该列的正确类型)。 |
返回
DataTableBuilder
- this 构建器,用于链式调用
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-07-26。
[null,null,["最后更新时间 (UTC):2025-07-26。"],[[["\u003cp\u003eDataTableBuilder facilitates the creation of DataTable objects by defining columns and adding rows sequentially.\u003c/p\u003e\n"],["\u003cp\u003eColumns are defined using \u003ccode\u003eaddColumn\u003c/code\u003e with specified data type and label, and rows are added using \u003ccode\u003eaddRow\u003c/code\u003e with corresponding values.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003ebuild\u003c/code\u003e method finalizes the DataTable construction and returns the resulting object.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003esetValue\u003c/code\u003e allows modification of individual cell values within the table by specifying row, column, and the new value.\u003c/p\u003e\n"],["\u003cp\u003eDataTableBuilder uses a chaining pattern, where method calls can be linked for streamlined table construction.\u003c/p\u003e\n"]]],[],null,["# Class DataTableBuilder\n\nDataTableBuilder\n\nBuilder of DataTable objects. Building a data table consists of first specifying its columns, and\nthen adding its rows, one at a time. Example:\n\n```javascript\nconst data = Charts.newDataTable()\n .addColumn(Charts.ColumnType.STRING, 'Month')\n .addColumn(Charts.ColumnType.NUMBER, 'In Store')\n .addColumn(Charts.ColumnType.NUMBER, 'Online')\n .addRow(['January', 10, 1])\n .addRow(['February', 12, 1])\n .addRow(['March', 20, 2])\n .addRow(['April', 25, 3])\n .addRow(['May', 30, 4])\n .build();\n``` \n\n### Methods\n\n| Method | Return type | Brief description |\n|-------------------------------------------------------------------|-------------------------------------------------------|-------------------------------------|\n| [addColumn(type, label)](#addColumn(ColumnType,String)) | [DataTableBuilder](#) | Adds a column to the data table. |\n| [addRow(values)](#addRow(Object)) | [DataTableBuilder](#) | Adds a row to the data table. |\n| [build()](#build()) | [DataTable](/apps-script/reference/charts/data-table) | Builds and returns a data table. |\n| [setValue(row, column, value)](#setValue(Integer,Integer,Object)) | [DataTableBuilder](#) | Sets a specific value in the table. |\n\nDetailed documentation\n----------------------\n\n### `add``Column(type, label)`\n\nAdds a column to the data table. Columns will be added from 0 to n.\n\nThe first column is often used by charts for labels (for instance, X-axis labels on line\ncharts, or slice labels in pie charts). The other columns are often used for data and therefore\noften require numeric values.\n\n#### Parameters\n\n| Name | Type | Description |\n|---------|---------------------------------------------------------|------------------------------------------------------|\n| `type` | [ColumnType](/apps-script/reference/charts/column-type) | type of data in the column (number, string, or date) |\n| `label` | `String` | label of the column (it's used for chart legends). |\n\n#### Return\n\n\n[DataTableBuilder](#) --- this builder, for chaining.\n\n*** ** * ** ***\n\n### `add``Row(values)`\n\nAdds a row to the data table.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------|------------|-------------------------------------------------------------------------------|\n| `values` | `Object[]` | values for the row, specified in the same order that the columns are entered. |\n\n#### Return\n\n\n[DataTableBuilder](#) --- this builder, for chaining.\n\n*** ** * ** ***\n\n### `build()`\n\nBuilds and returns a data table.\n\n#### Return\n\n\n[DataTable](/apps-script/reference/charts/data-table) --- the data table\n\n#### Throws\n\n\n[`Error`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Error) --- if the data table is empty or otherwise malformed\n\n*** ** * ** ***\n\n### `set``Value(row, column, value)`\n\nSets a specific value in the table.\n\nYou may set a value before adding the column to the data table. However, unless the column\nis added at some point, the value will be ignored.\n\nNot all column values need to be filled in. Those missing will be considered `null`.\n\n#### Parameters\n\n| Name | Type | Description |\n|----------|-----------|--------------------------------------------------------------------------|\n| `row` | `Integer` | the row index (the first row has index 0) |\n| `column` | `Integer` | the column index (the first column has index 0) |\n| `value` | `Object` | the value of the table cell (should have the right type for the column). |\n\n#### Return\n\n\n[DataTableBuilder](#) --- this builder, for chaining"]]