chart – Displays Google Sheet data as a chart instead of a table. Valid values are:
-
- AnnotatedTimeLine
- Annotation
- Area
- Bar
- Bubble
- Candlestick
- Column
- Combo
- Gauge
- Geo
- Histogram
- Line
- Pie
- Scatter
- Stepped
- Timeline
- class – An optional custom HTML class value or space-separated list of values. The following class names are treated specially:
no-datatables deactivates all DataTables features.
no-responsive deactivates only DataTables’ Responsive features.
FixedHeader or its synonym, FixedHeader-top, freezes the table header (its content) to the top of the window while scrolling vertically.
chart_aggregation_targetchart_all_values_suffixchart_allow_htmlchart_allow_redrawchart_animationchart_annotationschart_annotations_widthchart_area_opacitychart_avoid_overlapping_grid_lineschart_axis_titles_positionchart_background_colorchart_barschart_bubblechart_candlestickchart_chart_areachart_color_axischart_colorschart_crosshairchart_curve_typechart_data_opacitychart_dataless_region_colorchart_date_formatchart_default_colorchart_dimensionschart_display_annotationschart_display_annotations_filterchart_display_date_bar_separatorchart_display_exact_valueschart_display_legend_dotschart_display_legend_valueschart_display_modechart_display_range_selectorchart_display_zoom_buttonschart_domainchart_enable_interactivitychart_enable_region_interactivitychart_explorerchart_fillchart_focus_targetchart_font_namechart_font_sizechart_force_i_framechart_green_colorchart_green_fromchart_green_tochart_h_axeschart_h_axischart_heightchart_highlight_dotchart_interpolate_nullschart_is_stackedchart_keep_aspect_ratiochart_legendchart_line_widthchart_magnifying_glasschart_major_tickschart_marker_opacitychart_maxchart_minchart_minor_tickschart_number_formatschart_orientationchart_pie_holechart_pie_residue_slice_colorchart_pie_residue_slice_labelchart_pie_slice_border_colorchart_pie_slice_textchart_pie_slice_text_stylechart_pie_start_anglechart_point_shapechart_point_sizechart_red_colorchart_red_fromchart_red_tochart_regionchart_resolutionchart_reverse_categorieschart_scale_columnschart_scale_formatchart_scale_typechart_selection_modechart_serieschart_size_axischart_slice_visibility_thresholdchart_sliceschart_tablechart_themechart_thicknesschart_timelinechart_title_positionchart_title_text_stylechart_tooltipchart_trendlineschart_v_axeschart_v_axischart_widthchart_wmodechart_yellow_colorchart_yellow_fromchart_yellow_tochart_zoom_end_timechart_zoom_start_time
FixedHeader-footer freezes the table footer (itscontent) to the bottom of the window while scrolling vertically.
FixedHeader-left or FixedHeader-right freezes the left- or right-most column of the table while scrolling horizontally. (You will also need to set datatables_scroll_x=”true” in your shortcode to enable horizontal scrolling.)
FixedColumns-left-N or FixedColumns-right-N freezes the left- or right-most N columns in the table, respectively. For example, class=”FixedColumns-left-3″ will freeze the three left-most columns.
csv_headers – Whether or not to include textual headers in Google Sheet CSV exports when using query or chart. (Default: 0, which is to exclude them, which is equivalent to the Google default. Use 1 to include them.)
expire_in – How long to cache responses for, in seconds. Set this to 0 to cache forever. (Default: 600, which is ten minutes.)
footer_rows – A number specifying how many trailing rows to place in the output’s element. (Default: 0.)
header_cols – A number specifying how many column cells should be written withelements. (Default: 0.)
header_rows – A number specifying how many leading rows to place in the output’selement. (Default: 1.)
height – Height of the containing HTML element. Tables ignore this, use style instead. (Default: automatically calculated.)
http_opts – A JSON string representing options to pass to the WordPress HTTP API, like .
lang – The ISO 639 language code declaring the human language of the spreadsheet’s contents. For instance, use nl-NL to declare that content is in Dutch. (Default: your site’s global language setting.)
linkify – Whether or not to automatically turn URLs, email addresses, and so on, into clickable links. Set to no to disable this behavior. (Default: true.)
query – A Google Query Language query if the data source is a Google Spreadsheet or CSV file, or a SQL SELECT statement if the data source is a MySQL database. Note: Arrow bracktets (< and >) in queries must be URL-encoded (%3C and %3E, respectively) to avoid confusing the WordPress HTML parser. (Default: none.)
strip – The number of leading data source rows to omit from the resulting HTML table. (Default: 0.)
style – An inline CSS rule applied to the containing HTML element. For example, to set a fixed height on a table, use . (Default: none.)
summary – A brief description of the information displayed for the summary attribute of the resulting HTML