From DT v0.9 by Yihui Xie


Create an HTML table widget using the DataTables library

This function creates an HTML widget to display rectangular data (a matrix or data frame) using the JavaScript library DataTables.

datatable(data, options = list(), class = "display", callback = JS("return table;"), 
    rownames, colnames, container, caption = NULL, filter = c("none", 
        "bottom", "top"), escape = TRUE, style = "default", width = NULL, 
    height = NULL, elementId = NULL, fillContainer = getOption("DT.fillContainer", 
        NULL), autoHideNavigation = getOption("DT.autoHideNavigation", 
        NULL), selection = c("multiple", "single", "none"), extensions = list(), 
    plugins = NULL, editable = FALSE)

a data object (either a matrix or a data frame)


a list of initialization options (see; the character options wrapped in JS() will be treated as literal JavaScript code instead of normal character strings; you can also set options globally via options(DT.options = list(...)), and global options will be merged into this options argument if set


the CSS class(es) of the table; see


the body of a JavaScript callback function with the argument table to be applied to the DataTables instance (i.e. table)


TRUE (show row names) or FALSE (hide row names) or a character vector of row names; by default, the row names are displayed in the first column of the table if exist (not NULL)


if missing, the column names of the data; otherwise it can be an unnamed character vector of names you want to show in the table header instead of the default data column names; alternatively, you can provide a named numeric or character vector of the form 'newName1' = i1, 'newName2' = i2 or c('newName1' = 'oldName1', 'newName2' = 'oldName2', ...), where newName is the new name you want to show in the table, and i or oldName is the index of the current column name


a sketch of the HTML table to be filled with data cells; by default, it is generated from htmltools::tags$table() with a table header consisting of the column names of the data


the table caption; a character vector or a tag object generated from htmltools::tags$caption()


whether/where to use column filters; none: no filters; bottom/top: put column filters at the bottom/top of the table; range sliders are used to filter numeric/date/time columns, select lists are used for factor columns, and text input boxes are used for character columns; if you want more control over the styles of filters, you can provide a list to this argument of the form list(position = 'top', clear = TRUE, plain = FALSE), where clear indicates whether you want the clear buttons in the input boxes, and plain means if you want to use Bootstrap form styles or plain text input styles for the text input boxes


whether to escape HTML entities in the table: TRUE means to escape the whole table, and FALSE means not to escape it; alternatively, you can specify numeric column indices or column names to indicate which columns to escape, e.g. 1:5 (the first 5 columns), c(1, 3, 4), or c(-1, -3) (all columns except the first and third), or c('Species', 'Sepal.Length'); since the row names take the first column to display, you should add the numeric column indices by one when using rownames


the style name (; currently only 'default' and 'bootstrap' are supported

width, height

Width/Height in pixels (optional, defaults to automatic sizing)


An id for the widget (a random string by default).


TRUE to configure the table to automatically fill it's containing element. If the table can't fit fully into it's container then vertical and/or horizontal scrolling of the table cells will occur.


TRUE to automatically hide navigational UI when the number of total records is less than the page size.


the row/column selection mode (single or multiple selection or disable selection) when a table widget is rendered in a Shiny app; alternatively, you can use a list of the form list(mode = 'multiple', selected = c(1, 3, 8), target = 'row') to pre-select rows; the element target in the list can be 'column' to enable column selection, or 'row+column' to make it possible to select both rows and columns (click on the footer to select columns), or 'cell' to select cells


a character vector of the names of the DataTables extensions (


a character vector of the names of DataTables plug-ins ( Note that only those plugins supported by the DT package can be used here.


FALSE to disable the table editor, or TRUE (or "cell") to enable editing a single cell. Alternatively, you can set it to "row" to be able to edit a row, or "column" to edit a column, or "all" to edit all cells on the current page of the table. In all modes, start editing by doubleclicking on a cell. This argument can also be a list of the form list(target = TARGET, disable = list(columns = INDICES)), where TARGET can be cell, row, column, or all, and INDICES is an integer vector of column indices. Use the list form if you want to disable editing certain columns.


You are recommended to escape the table content for security reasons (e.g. XSS attacks) when using this function in Shiny or any other dynamic web applications.


See for the full documentation.

  • datatable

# see the package vignette for examples and the link to website
vignette('DT', package = 'DT')

# some boring edge cases for testing purposes
m = matrix(nrow = 0, ncol = 5, dimnames = list(NULL, letters[1:5]))
datatable(m)  # zero rows

m = matrix(1, dimnames = list(NULL, 'a'))
datatable(m)  # one row and one column

m = data.frame(a = 1, b = 2, c = 3)

# dates
  date = seq(as.Date("2015-01-01"), by = "day", length.out = 5), x = 1:5
datatable(data.frame(x = Sys.Date()))
datatable(data.frame(x = Sys.time()))
# }
Documentation reproduced from package DT, version 0.9, License: GPL-3 | file LICENSE

Community examples

Looks like there are no examples yet.