TableView

TableView[{{expr₁₁,expr₁₂,…},{expr₂₁,expr₂₂,…},…}]

displays as a spreadsheet-like table view for editing and viewing expr_ij.

takes the contents of the table view to be the dynamically updated current value of x, with the value of x being reset as the table view is interactively edited.

TableView[table,type]

uses the specified type by default to represent newly edited or created entries in the table view.

TableView[]

displays an empty table view.

Details and Options

TableView produces an interface that works similarly to common spreadsheet interfaces. Columns may be resized. Selections of entire rows, columns or blocks may be cut and pasted. Strings and numbers are automatically differentiated upon editing. The view may be scrolled to accommodate large numbers of entries.
The following are possible values of type:

	Number	number
	String	string
	Expression	expression
	Hold[Expression]	expression in held form
	Boxes	raw boxes
	{Number,String}	use numbers when possible, or strings otherwise

When type is not specified, TableView defaults to {Number,String}.
The following options can be given:

Alignment	{Center,Baseline}	horizontal and vertical alignment of items
AllowedDimensions	Automatic	restrictions on number of rows or columns
AppearanceElements	Automatic	elements to include in the displayed view
Background	None	what background colors to use
BaselinePosition	Automatic	what to align with a surrounding text baseline
BaseStyle	{}	base style specifications for the grid
Enabled	True	whether the individual entries can be edited
HeaderSize	Automatic	width and height of headers
Headers	Automatic	row and column labels
ImageSize	Automatic	the overall size of the table view
ItemSize	Automatic	width and height of each item
ItemStyle	None	styles for columns and rows
Scrollbars	Automatic	whether to include scrollbars
ScrollPosition	{0,0}	scroll position if scrolling is enabled

Settings for the options Alignment, Background, ItemSize and ItemStyle can be given as follows to apply separately to different items:

	spec	apply spec to all items
	{spec_x}	apply spec_x at successive horizontal positions
	{spec_x,spec_y}	apply spec_k at successive horizontal and vertical positions
	{spec_x,spec_y,rules}	also allow explicit rules for individual i, j elements

The spec_k can have the following forms:

	{s₁,s₂,…,s_n}	use s₁ through s_n, then use defaults
	{{c}}	use c in all cases
	{{c₁,c₂}}	alternate between c₁ and c₂
	{{c₁,c₂,…}}	cycle through all c_i
	{s,{c}}	use s, then repeatedly use c
	{s₁,s₂,…,{c₁, c₂,…},s_m,…,s_n}	use the first sequence of s_i at the beginning, then cyclically use c_i, then use the last sequence of s_i at the end
	{i₁->v₁,i₂->v₂,…}	specify what to use at positions i_k
	{spec,rules}	use rules to override specifications in spec

TableView supports viewing and creation of ragged tables of data.
Empty entries in TableView are omitted upon evaluation if they can be clipped from the right edge of the table. If empty entries are within a table, they are represented as empty strings or Null as appropriate for the specified type.
Setting may be used with TableView to extract the underlying data.
TableView is specifically designed to allow efficient viewing, editing and file storage of very large tables of data in notebooks.
Possible elements in AppearanceElements include "RowHeaders", "CollapsedRowHeaders", "ColumnHeaders", "CollapsedColumnHeaders", "Frame" and "ResizeArea".

Examples

open allclose all

Basic Examples (2)

Numerical data in TableView:

Numbers and strings:

Scope (11)

Structure (5)

An empty TableView:

A regular array of data:

A ragged array of data:

Arrays with empty fields:

Empty rows and columns:

Types (6)

Numbers:

Strings:

Mixed data:

Expressions:

Images and graphics:

Boxes:

Options (20)

Alignment (1)

Center content:

AllowedDimensions (2)

Set the dimensions to be exactly 4 columns by 3 rows:

Automatic scrollbars appear if the allowed dimensions cannot be displayed all at once:

With unconstrained dimensions, the scroll position can be set arbitrarily high:

With constrained dimensions, the scroll position will not move past the constraints:

AppearanceElements (2)

Show collapsed headers and collapsed columns:

The "Frame" element always displays as a thin gray frame:

To use a customized frame, omit the "Frame" element and use Framed:

Background (7)

Draw the view with a pink background:

Pink and gray backgrounds for the columns at the first and second horizontal positions:

An equivalent syntax:

Pink and gray backgrounds for the rows at the first and second vertical positions:

Alternating pink and gray backgrounds:

Alternating backgrounds with yellow superimposed in the first and last positions:

Blending of colors:

Set the background for specific items:

Set the background for a subregion of the grid:

BaselinePosition (2)

Align the center of the grid with the baseline of surrounding text:

Align the bottom of the grid with the baseline:

HeaderSize (1)

Make the first column wider:

ImageSize (1)

Display views at various sizes:

Scrollbars (3)

By default, scrollbars do not appear if the TableView can display all of the data at once:

They do appear if the data would otherwise be clipped:

Always display scrollbars, even when the data fits within the view:

Suppress scrollbars even if the data would be clipped at the current ImageSize:

ScrollPosition (1)

Specify the initial position of a view:

Properties & Relations (1)

TableView takes many of the same options as Grid with similar specifications:

Unlike Grid, TableView has no right or bottom; specifications of the right or bottom do not do anything:

Neat Examples (1)

Use Magnify to see an overview of a large number of cells:

Top