Google Apps Script
  • Google Apps Script
Learn Apps Script Build add-ons Use the REST API
Sign in
  • Automate tasks with Apps Script
Guides Reference Samples Support
Google Apps Script
  • Google Apps Script
  • Learn Apps Script
    • Guides
    • Reference
    • Samples
    • Support
  • Build add-ons
  • Use the REST API
  • Overview
  • Google Workspace services
  • Admin Console
    • Advanced services
    • Directory API
    • Enterprise License Manager API
    • Groups Migration API
    • Groups Settings API
    • Reseller API
    • Reports API
  • Calendar
    • Overview
    • CalendarApp
    • Classes
    • Calendar
    • CalendarEvent
    • CalendarEventSeries
    • EventGuest
    • EventRecurrence
    • RecurrenceRule
    • Enums
    • Color
    • EventColor
    • GuestStatus
    • Visibility
    • Advanced services
    • Calendar API
  • Docs
    • Overview
    • DocumentApp
    • Classes
    • Body
    • Bookmark
    • ContainerElement
    • Date
    • Document
    • Equation
    • EquationFunction
    • EquationFunctionArgumentSeparator
    • EquationSymbol
    • FooterSection
    • Footnote
    • FootnoteSection
    • HeaderSection
    • HorizontalRule
    • InlineDrawing
    • InlineImage
    • ListItem
    • NamedRange
    • PageBreak
    • Paragraph
    • Person
    • Position
    • PositionedImage
    • Range
    • RangeBuilder
    • RangeElement
    • RichLink
    • Table
    • TableCell
    • TableOfContents
    • TableRow
    • Text
    • UnsupportedElement
    • Interfaces
    • Element
    • Enums
    • Attribute
    • ElementType
    • FontFamily
    • GlyphType
    • HorizontalAlignment
    • ParagraphHeading
    • PositionedLayout
    • TextAlignment
    • VerticalAlignment
    • Advanced services
    • Docs API
  • Drive
    • Overview
    • DriveApp
    • Classes
    • File
    • FileIterator
    • Folder
    • FolderIterator
    • User
    • Enums
    • Access
    • Permission
    • Advanced services
    • Drive API
    • Drive Activity API
  • Forms
    • Overview
    • FormApp
    • Classes
    • CheckboxGridItem
    • CheckboxGridValidation
    • CheckboxGridValidationBuilder
    • CheckboxItem
    • CheckboxValidation
    • CheckboxValidationBuilder
    • Choice
    • DateItem
    • DateTimeItem
    • DurationItem
    • Form
    • FormResponse
    • GridItem
    • GridValidation
    • GridValidationBuilder
    • ImageItem
    • ItemResponse
    • ListItem
    • MultipleChoiceItem
    • PageBreakItem
    • ParagraphTextItem
    • ParagraphTextValidation
    • ParagraphTextValidationBuilder
    • QuizFeedback
    • QuizFeedbackBuilder
    • ScaleItem
    • SectionHeaderItem
    • TextItem
    • TextValidation
    • TextValidationBuilder
    • TimeItem
    • VideoItem
    • Interfaces
    • Item
    • Enums
    • Alignment
    • DestinationType
    • FeedbackType
    • ItemType
    • PageNavigationType
  • Gmail
    • Overview
    • GmailApp
    • Classes
    • GmailAttachment
    • GmailDraft
    • GmailLabel
    • GmailMessage
    • GmailThread
    • Advanced services
    • Gmail API
  • Sheets
    • Overview
    • SpreadsheetApp
    • Classes
    • Banding
    • BigQueryDataSourceSpec
    • BigQueryDataSourceSpecBuilder
    • BooleanCondition
    • CellImage
    • CellImageBuilder
    • Color
    • ColorBuilder
    • ConditionalFormatRule
    • ConditionalFormatRuleBuilder
    • ContainerInfo
    • DataExecutionStatus
    • DataSource
    • DataSourceChart
    • DataSourceColumn
    • DataSourceFormula
    • DataSourceParameter
    • DataSourcePivotTable
    • DataSourceRefreshSchedule
    • DataSourceRefreshScheduleFrequency
    • DataSourceSheet
    • DataSourceSheetFilter
    • DataSourceSpec
    • DataSourceSpecBuilder
    • DataSourceTable
    • DataSourceTableColumn
    • DataSourceTableFilter
    • DataValidation
    • DataValidationBuilder
    • DateTimeGroupingRule
    • DeveloperMetadata
    • DeveloperMetadataFinder
    • DeveloperMetadataLocation
    • Drawing
    • EmbeddedAreaChartBuilder
    • EmbeddedBarChartBuilder
    • EmbeddedChart
    • EmbeddedChartBuilder
    • EmbeddedColumnChartBuilder
    • EmbeddedComboChartBuilder
    • EmbeddedHistogramChartBuilder
    • EmbeddedLineChartBuilder
    • EmbeddedPieChartBuilder
    • EmbeddedScatterChartBuilder
    • EmbeddedTableChartBuilder
    • Filter
    • FilterCriteria
    • FilterCriteriaBuilder
    • GradientCondition
    • Group
    • NamedRange
    • OverGridImage
    • PageProtection
    • PivotFilter
    • PivotGroup
    • PivotGroupLimit
    • PivotTable
    • PivotValue
    • Protection
    • Range
    • RangeList
    • RichTextValue
    • RichTextValueBuilder
    • Selection
    • Sheet
    • Slicer
    • SortSpec
    • Spreadsheet
    • SpreadsheetTheme
    • TextFinder
    • TextRotation
    • TextStyle
    • TextStyleBuilder
    • ThemeColor
    • Enums
    • AutoFillSeries
    • BandingTheme
    • BooleanCriteria
    • BorderStyle
    • CopyPasteType
    • DataExecutionErrorCode
    • DataExecutionState
    • DataSourceParameterType
    • DataSourceRefreshScope
    • DataSourceType
    • DataValidationCriteria
    • DateTimeGroupingRuleType
    • DeveloperMetadataLocationType
    • DeveloperMetadataVisibility
    • Dimension
    • Direction
    • FrequencyType
    • GroupControlTogglePosition
    • InterpolationType
    • PivotTableSummarizeFunction
    • PivotValueDisplayType
    • ProtectionType
    • RecalculationInterval
    • RelativeDate
    • SheetType
    • SortOrder
    • TextDirection
    • TextToColumnsDelimiter
    • ThemeColorType
    • ValueType
    • WrapStrategy
    • Advanced services
    • Sheets API
  • Slides
    • Overview
    • SlidesApp
    • Classes
    • AffineTransform
    • AffineTransformBuilder
    • AutoText
    • Autofit
    • Border
    • Color
    • ColorScheme
    • ConnectionSite
    • Fill
    • Group
    • Image
    • Layout
    • Line
    • LineFill
    • Link
    • List
    • ListStyle
    • Master
    • NotesMaster
    • NotesPage
    • Page
    • PageBackground
    • PageElement
    • PageElementRange
    • PageRange
    • Paragraph
    • ParagraphStyle
    • PictureFill
    • Point
    • Presentation
    • Selection
    • Shape
    • SheetsChart
    • Slide
    • SolidFill
    • Table
    • TableCell
    • TableCellRange
    • TableColumn
    • TableRow
    • TextRange
    • TextStyle
    • ThemeColor
    • Video
    • WordArt
    • Enums
    • AlignmentPosition
    • ArrowStyle
    • AutoTextType
    • AutofitType
    • CellMergeState
    • ContentAlignment
    • DashStyle
    • FillType
    • LineCategory
    • LineFillType
    • LineType
    • LinkType
    • ListPreset
    • PageBackgroundType
    • PageElementType
    • PageType
    • ParagraphAlignment
    • PlaceholderType
    • PredefinedLayout
    • SelectionType
    • ShapeType
    • SheetsChartEmbedType
    • SlideLinkingMode
    • SlidePosition
    • SpacingMode
    • TextBaselineOffset
    • TextDirection
    • ThemeColorType
    • VideoSourceType
    • Advanced services
    • Slides API
  • More...
    • Classroom
      • Advanced services
      • Classroom API
    • Contacts
      • Overview
      • ContactsApp
      • Classes
      • AddressField
      • CompanyField
      • Contact
      • ContactGroup
      • CustomField
      • DateField
      • EmailField
      • IMField
      • PhoneField
      • UrlField
      • Enums
      • ExtendedField
      • Field
      • Gender
      • Priority
      • Sensitivity
      • Advanced services
      • People API
    • Groups
      • Overview
      • GroupsApp
      • Classes
      • Group
      • Enums
      • Role
    • Sites (Classic)
      • Overview
      • SitesApp
      • Classes
      • Attachment
      • Column
      • Comment
      • ListItem
      • Page
      • Site
      • Enums
      • AttachmentType
      • PageType
    • Tasks
      • Advanced services
      • Tasks API
  • Other Google services
  • Google Analytics
    • Advanced services
    • Management and Reporting APIs
    • Analytics Data API
  • Google Maps
    • Overview
    • Maps
    • Classes
    • DirectionFinder
    • DirectionFinderEnums
    • ElevationSampler
    • Geocoder
    • StaticMap
    • StaticMapEnums
    • Enums
    • Avoid
    • Color
    • Format
    • MarkerSize
    • Mode
    • Type
  • Google Translate
    • Overview
    • LanguageApp
  • YouTube
    • Advanced services
    • YouTube Data API
    • YouTube Analytics API
    • YouTube Content ID API
  • More...
    • Google Ads & Merchant Center
      • AdSense
        • Advanced services
        • AdSense Management API
      • DoubleClick Campaigns
        • Advanced services
        • DCM/DFA Reporting and Trafficking API
      • Shopping Content
        • Advanced services
        • Google Content API for Shopping
    • Google Data Studio
      • Overview
      • DataStudioApp
      • Classes
      • BigQueryConfig
      • Checkbox
      • CommunityConnector
      • Config
      • DebugError
      • Field
      • Fields
      • GetAuthTypeResponse
      • GetDataResponse
      • GetSchemaResponse
      • Info
      • OptionBuilder
      • SelectMultiple
      • SelectSingle
      • SetCredentialsResponse
      • TextArea
      • TextInput
      • UserError
      • Enums
      • AggregationType
      • AuthType
      • BigQueryParameterType
      • FieldType
    • Google Tables
      • Advanced services
      • Tables API
    • Google Tag Manager
      • Advanced services
      • Tag Manager API
  • Utility services
  • API & database connections
    • BigQuery
      • Advanced services
      • BigQuery API
    • JDBC
      • Overview
      • Jdbc
      • Classes
      • JdbcArray
      • JdbcBlob
      • JdbcCallableStatement
      • JdbcClob
      • JdbcConnection
      • JdbcDatabaseMetaData
      • JdbcDate
      • JdbcParameterMetaData
      • JdbcPreparedStatement
      • JdbcRef
      • JdbcResultSet
      • JdbcResultSetMetaData
      • JdbcRowId
      • JdbcSQLXML
      • JdbcSavepoint
      • JdbcStatement
      • JdbcStruct
      • JdbcTime
      • JdbcTimestamp
    • URL Fetch
      • Overview
      • UrlFetchApp
      • Classes
      • HTTPResponse
      • OAuthConfig Migration
  • Data usability & optimization
    • Optimization
      • Overview
      • LinearOptimizationService
      • Classes
      • LinearOptimizationConstraint
      • LinearOptimizationEngine
      • LinearOptimizationSolution
      • Enums
      • Status
      • VariableType
    • Utilities
      • Overview
      • Utilities
      • Enums
      • Charset
      • DigestAlgorithm
      • MacAlgorithm
      • RsaAlgorithm
    • XML
      • Overview
      • XmlService
      • Classes
      • Attribute
      • Cdata
      • Comment
      • DocType
      • Document
      • Element
      • EntityRef
      • Format
      • Namespace
      • ProcessingInstruction
      • Text
      • Interfaces
      • Content
      • Enums
      • ContentType
  • HTML & content
    • Charts
      • Overview
      • Charts
      • Classes
      • AreaChartBuilder
      • BarChartBuilder
      • Chart
      • ChartOptions
      • ColumnChartBuilder
      • DataTable
      • DataTableBuilder
      • DataViewDefinition
      • DataViewDefinitionBuilder
      • LineChartBuilder
      • NumberRangeFilterBuilder
      • PieChartBuilder
      • ScatterChartBuilder
      • StringFilterBuilder
      • TableChartBuilder
      • TextStyle
      • TextStyleBuilder
      • Interfaces
      • DataTableSource
      • Enums
      • ChartHiddenDimensionStrategy
      • ChartMergeStrategy
      • ChartType
      • ColumnType
      • CurveStyle
      • MatchType
      • Orientation
      • PickerValuesLayout
      • PointStyle
      • Position
    • Content
      • Overview
      • ContentService
      • Classes
      • TextOutput
      • Enums
      • MimeType
    • HTML
      • Overview
      • google.script.history (client-side)
      • google.script.host (client-side)
      • google.script.run (client-side)
      • google.script.url (client-side)
      • HtmlService
      • Classes
      • HtmlOutput
      • HtmlOutputMetaTag
      • HtmlTemplate
      • Enums
      • SandboxMode
      • XFrameOptionsMode
    • Mail
      • Overview
      • MailApp
  • Script execution & information
    • Base
      • Overview
      • Browser
      • Logger
      • MimeType
      • Session
      • console
      • Classes
      • Blob
      • Menu
      • PromptResponse
      • RgbColor
      • Ui
      • User
      • Interfaces
      • BlobSource
      • Enums
      • Button
      • ButtonSet
      • ColorType
      • Month
      • Weekday
    • Cache
      • Overview
      • CacheService
      • Classes
      • Cache
    • Lock
      • Overview
      • LockService
      • Classes
      • Lock
    • Properties
      • Overview
      • PropertiesService
      • ScriptProperties
      • UserProperties
      • Classes
      • Properties
    • Script
      • Overview
      • ScriptApp
      • Classes
      • AuthorizationInfo
      • CalendarTriggerBuilder
      • ClockTriggerBuilder
      • DocumentTriggerBuilder
      • FormTriggerBuilder
      • Service
      • SpreadsheetTriggerBuilder
      • StateTokenBuilder
      • Trigger
      • TriggerBuilder
      • Enums
      • AuthMode
      • AuthorizationStatus
      • EventType
      • InstallationSource
      • TriggerSource
  • Script project resources
  • Automation triggers and events
    • Simple triggers
    • Installable triggers
    • Event objects
  • Manifest
    • Overview
    • Libraries & advanced services
    • Web apps and API executables
    • Sheets macros
    • Google Workspace Add-ons
    • Allowlist URLs
  • Quotas & limits
  • Add-on resources
  • Add-ons reference docs
  • Home
  • Products
  • Google Workspace for Developers
  • Apps Script
  • Learn Apps Script
  • Reference

Class DataTable

DataTable

A Data Table to be used in charts. A DataTable can come from sources such as Google Sheets or specified data-table URLs, or can be filled in by hand. This class intentionally has no methods: a DataTable can be passed around, but not manipulated directly.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2018-06-26 UTC.

  • Blog Blog
    Read the Google Workspace Developers blog
  • Stack Overflow Stack Overflow
    Ask a question under the google-apps-script tag
  • Code Samples Code Samples
    Explore our code samples or copy them to build your own
  • Videos Videos
    Watch Apps Script tutorials
  • Google Workspace for Developers

    • Platform overview
    • Developer products
    • Developer support
    • Terms of Service
  • Tools

    • Admin Console
    • Apps Script Dashboard
    • Google Cloud Console
  • Connect

    • Blog
    • Newsletter
    • Twitter
    • YouTube
Google Developers
  • Android
  • Chrome
  • Firebase
  • Google Cloud Platform
  • All products
  • Terms
  • Privacy
  • Sign up for the Google Developers newsletter Subscribe