To declare a table object, use the keyword table, followed by an optional row and column dimension, and then the object name:

If no dimension is provided, the table will contain a single element.

Alternatively, you may declare a table using an assignment statement. The new table will be sized and initialized, accordingly:

Lastly, you may use the freeze command to create tables from tabular views of other objects:

Note that with the exception of tabplace, these commands are supported primarily for backward compatiblity. There is a more extensive set of table procs for working with and customizing tables. See “Table Procs”.

Removes the table’s history attribute, as shown in the label view of the table.

The first line removes the history from the table T1, and the second line displays the label view of T1, including the now blank history field.

See “Labeling Objects” for a discussion of labels and display names.

See also Table::label.

Removes the table’s remarks attribute, as shown in the label view of the table.

The first line removes the remarks from the table T1, and the second line displays the label view of T1, including the now blank remarks field.

See “Labeling Objects” for a discussion of labels and display names.

See also Table::label.

where cell_arg, which identifies the cell, can take one of the following forms:

and where comment_arg is a string expression enclosed in double quotes. If command_arg is omitted, a previously defined comment will be removed.

To add a comment, “hello world”, to the cell in the second row, fourth column, you may use one of the following:

To remove a comment, simply omit the comment_arg:

clears the comment (if present) from the second row, fourth column.

For additional discussion of table commands see “Working with Tables and Spreadsheets”. See also Table::setlines and Table::setmerge.

Creates either a named or unnamed copy of the table.

creates an unnamed copy of the table T1.

creates T2, a copy of the table T1.

See also copy.

Options are specified in parentheses after the keyword and are used to specify the format of the data in the destination table.

The copyrange command can be specified either using coordinates where columns are signified with a letter, and rows by a number (for example “A3” represents the first column, third row), or by row number and column number.

The first syntax represents coordinate form, where s1 specifies the upper-left coordinate portion of the section of the source table to be copied, s2 specifies the bottom-right coordinate, destname specifies the name of the table to copy to, and d1 specifies the upper-left coordinate of the destination table.

The second syntax represents the row/column number form, where sr1 specifies the source table upper row number, sc1 specifies the source table left most column number, sr2 specifies the source table bottom row number, sc2 specifies the source table right most column number. destname specifies the name of the table to copy to, and dr1 and dr2 specify the upper and left most row and column of the destination table, respectively.

places a copy of the data from cell range B2 to D4 in TABLE1 to TABLE2 at cell A1

copies 5 rows of data in the first column of data in table1 and places a transpose of the data at the top of the 3rd column of TABLE2.

See also Table::copytable.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

The copytable command can be specified either using coordinates where columns are signified with a letter, and rows by a number (for example “A3” represents the first column, third row), or by row number and column number.

The first syntax represents coordinate form, where destname specifies the name of the table to copy to, and d1 specifies the upper-left coordinate of the destination table.

The second syntax represents the row/column number form, where destname specifies the name of the table to copy to, and dr1 and dr2 specify the upper and left most row and column of the destination table, respectively.

copies all of the data in TABLE1 to the 1st column and 10th row of TABLE2.

copies all of the data in TABLE1 to the 5th column and first row of TABLE2.

See also Table::copyrange.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where delete_arg specifies what to delete or how the surrounding cells should be moved.

The cell_range argument defines the cells to be modified. See Table::setformat for the syntax.

delete_arg may be one of the following:

deletes rows 2 through 5 from the table TAB1.

deletes cells B2 through E5 from the table TAB1 and moves all the cells right of and including F2 and F5 to the left in place of B2 and B5 respectively.

deletes cells B2 through E5 from the table TAB1 and moves all the cells below and including B5 and F5 up in place of B2 and E5 respectively.

You may delete cells conditionally. For example, to delete the cell e17 if cell b3 is less than c4 and shift the remaining cells in the row to the left:

Or to delete the range of cells from c7 to d17 if cell b3 is greater than c4 and shift the remaining cells to the left:

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

where col_loc specifies the first column to be removed. The col_loc may either be the integer column number (e.g. “3”) or the column letter (e.g. “C”).

The num_cols specifies the number of columns to remove from the table. If num_cols is not provided, the default is one.

removes two columns beginning at the “d” or fourth column.

For other row and columns operations, see Table::deleterow, Table::insertcol, and Table::insertrow.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where row_loc is an integer which specifies the first row to remove, and num_rows specifies the number of rows to remove from the table. If num_rows is not provided, the default is one.

removes five rows beginning with the second row.

For other row and columns operations, see Table::deletecol, Table::insertcol, and Table::insertrow.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

Display the contents of a table, graph, or spool in the window of the table object.

Display the contents of the table TAB1 in the window of the object TABLE1.

See “Labeling Objects” for a discussion of labels and display names. See also Table::label.

Attaches a display name to a table object which may be used to label output in place of the standard table object name.

Display names are case-sensitive, and may contain a variety of characters, such as spaces, that are not allowed in table object names.

The first line attaches a display name “Hours Worked” to the table object HRS, and the second line displays the label view of HRS, including its display name.

See “Labeling Objects” for a discussion of labels and display names.

See also Table::label.

where cols is the number of columns to be fixed

fixes the first 3 columns of the table TAB1 such that they are always in view despite the horizontal scroll position.

removes any fixed columns in table TAB1.

where rows is the number of rw to be fixed

fixes the first 2 rows of the table TAB1 such that they are always in view despite the vertical scroll position.

removes any fixed rows in table TAB1.

where rows is the number of rows to be fixed and cols is the number of columns to be fixed.

fixes the first row and the first 4 columns of the table TAB1 such that they are always in view despite the horizontal and vertical scroll position of the table.

removes all fixed rows and columns in table TAB1.

in table TAB1 removes all fixed rows but fixes the first 4 columns.

See also Table::fixcol and Table::fixrow.

where insert_arg specifies what to be inserted or how the surrounding cells should be shifted.

The cell_range argument defines the cells to be modified. See Table::setformat for the syntax.

insert_arg may be one of the following:

inserts four new rows starting at row 2 in the table TAB1.

shifts the cells to the right of and including B2 through E5 in table TAB1 by four columns.

shifts the cells below and including B2 through E5 in table TAB1 by four rows.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

where col_loc specifies the column location to insert the new columns. The col_loc may either be the integer column number (e.g. “3”) or the column letter (e.g. “C”).

The num_cols specifies the number of columns to insert into the table. If num_cols is not provided, the default is one.

inserts two new columns beginning at the “d” or fourth column.

You may do conditional column insertions. This will insert four columns after each column from b to d if cell b7 is greater than each cell f7 to h7:

For other row and columns operations, see Table::deleterow, Table::deletecol, and Table::insertrow.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where row_loc is an integer which specifies the row location to insert the new rows, and num_rows specifies the number of rows to insert. If num_rows is not provided, the default is one.

inserts five new rows beginning at the second row.

You may do conditional row insertions. This will insert four rows after each row from b to d if cell b7 is greater than each cell f7 to h7:

For other row and columns operations, see Table::deleterow, Table::deletecol, and Table::insertcol.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where row_loc is an integer which specifies the row location to insert the new rows, and num_rows specifies the number of rows to insert. If num_rows is not provided, the default is one.

inserts five new rows beginning at the second row.

For other row and columns operations, see Table::deleterow, Table::deletecol, and Table::insertcol.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

As a procedure, label changes the fields in the table label.

The first version of the command displays the label view of the table. The second version may be used to modify the label. Specify one of the following options along with optional text. If there is no text provided, the specified field will be cleared.

The following lines replace the remarks field of the table TAB1 with “Data from CPS 1988 March File”:

To append additional remarks to TAB1, and then to print the label view:

To clear and then set the units field, use:

See “Labeling Objects” for a discussion of labels.

See also Table::displayname.

See “Object Linking and Embedding (OLE)” for a discussion of using OLE with EViews.

Follow the keyword with a name for the file. file_name may include the file type extension, or the file type may be specified using the “t=” option.

If an explicit path is not specified, the file will be stored in the default directory, as set in the File Locations global options.

The base syntax for writing Excel files is:

where the following table_description elements may be employed:

If the worksheet name contains spaces, it should be placed in single quotes. If the worksheet name is omitted, the cell range is assumed to refer to the currently active sheet. If only a top left cell is provided, a bottom right cell will be chosen automatically to cover the range of non-empty cells adjacent to the specified top left cell. If only a sheet name is provided, the first set of non-empty cells in the top left corner of the chosen worksheet will be selected automatically. As an alternative to specifying an explicit range, a name which has been defined inside the excel workbook to refer to a range or cell may be used to specify the cells to read.

The command:

saves TAB1 to a CSV file named “mytable.CSV” in the default directory.

saves TAB1 to a CSV (comma separated value) file named “mytable.csv” and writes all NA values as “NaN”.

saves from data from the second row, second column, to the tenth row, third column of TAB1 to a HTML file named “mytable.HTM” at half of the original size.

saves the contents of the second column of the table in full precision to a CSV file named “mytable.CSV”, and writes all NA values as “.”.

adds TAB1 to the preexisting “mytable.XLSX” Excel file to the “Country” sheet at cell B5, where the cell colors and fonts in TAB1 will also be copied.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See “Table and Text Objects” for a discussion of tables.

Sets the attribute attr to attr_value. Note that quoting the arguments may be required. Once added to an object, the attribute may be extracted using the @attr data member.

sets the “revised” attribute in the object A to the string “never”, and extracts the attribute into the string object S.

See “Adding Custom Attributes in the Label View” and “Adding Your Own Label Attributes”.

where cell_range can take one of the following forms:

The color_arg specifies the color to be applied to the text in the cells. The color may be specified using predefined color names, by specifying the individual red-green-blue (RGB) components using the special “@RGB” function, or by specifying the individual red-green-blue (RGB) components in hexadecimal using the special “@HEX” function. The second and third methods are obviously more difficult, but allow you to use custom colors.

The predefined colors are given by the keywords (with their RGB and HEX equivalents):

To set a purple background color for the cell in the second row and third column of TAB1, you may use any of the following:

You may also specify a yellow color for the background of an entire column, or an entire row:

or for every other row, the background of the cells in a rectangular region:

You may conditionally set the fill color for a range of cells. For example, in the below command cells a3 to a18 will be yellow if the sum from a second range of cells (b4 to b19) added to a third range of cells (c4 to c19) is greater than 0.5. Specifically, cell a3 will be set to yellow if cell b4 plus cell c4 is greater than 0.5:

See Table::settextcolor and Table::setfont for details on changing text color and font, and Table::setlines for drawing lines between and through cells.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

The font_args may include one or more of the following:

and type is one of “all”, “axes”, “legend”, “text”, “obs”, where “axes” refers to the axes labels, “legend” refers to the graph legend, “text” refers to the text objects, “obs” refers to the observation scale, and “all” refers to all of the elements.

sets the font to Times New Roman Italic for the cells defined by the rectangle from B3 (row 3, column 2) to D10 (row 10, column 4).

changes all of text in the region to 8 point.

removes the italic, and adds boldface to the B4 cell (row 4, column 2).

The commands:

modify the fonts for the column B, and row 2, respectively. The first command changes the point size to 14, removes strikethrough and adds underscoring. The second changes the typeface to Batang, and adds underscoring,

See Table::settextcolor and Table::setfillcolor for details on changing text color and font, and Table::setlines for drawing lines between and through cells.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where format_arg is a set of arguments used to specify format settings. If necessary, you should enclose the format_arg in double quotes.

The cell_range option is used to describe the cells to be modified. It may take one of the following forms:

To format numeric values, you should use one of the following format specifications:

To specify a format that groups digits into thousands using a comma separator, place a “t” after the format character. For example, to obtain a fixed number of decimal places with commas used to separate thousands, use “ft[.precision]”.

To use the period character to separate thousands and commas to denote decimal places, use “..” (two periods) when specifying the precision. For example, to obtain a fixed number of characters with a period used to separate thousands, use “ct[..precision]”.

If you wish to display negative numbers surrounded by parentheses (i.e., display the number -37.2 as “(37.2)”), you should enclose the format string in “()” (e.g., “f(.8)”).

To format numeric values using date and time formats, you may use a subset of the possible date format strings (see “Date Formats”). The possible format arguments, along with an example of the date number 730856.944793113 (January 7, 2002 10:40:30.125 p.m) formatted using the argument are given by:

Note that the “hh” formats display 24-hour time without leading zeros. In our examples above, there is no difference between the “HH” and “hh” formats for 10 p.m.

Also note that all of the “YYYY” formats above may be displayed using two-digit year “YY” format.

To set the format of a cell to fixed 5-digit precision, provide the format specification and a valid cell specification:

You may use any of the date formats given above:

The cell specification may be described in a variety of ways:

You may conditionally set the format for a range of cells. For example, in the command below the cells from b20 to d25 will use format ‘e.5’ if the matching cells from the second range (b20 to d25) are greater than the cells from the third range (f10 to h15). Specifically, the format for cell b20 will be set to 'e.5' if cell b20 is greater than f10:

See Table::settextcolor and Table::setfillcolor for details on changing text color, and Table::setlines for drawing lines between and through cells. To set other cell properties, see Table::setheight, Table::setindent, Table::setjust, and Table::setwidth.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where row_range is either a single row number (e.g., “5”), a colon delimited range of rows (from low to high, e.g., “3:5”), or the “@ALL” keyword, and height_arg specifies the height unit value, where height units are specified in character heights. The character height is given by the font-specific sum of the units above and below the baseline and the leading, where the font is given by the default font for the current table (the EViews table default font at the time the table was created). height_arg values may be non-integer values with resolution up to 1/10 of a height unit.

sets the height of row 2 to match the table font character height, while:

increases the row height to 1-1/2 character heights.

Similarly, the command:

sets the heights for rows 2 through 4.

You many conditionally set the row height. This command will set the individual row height of rows 10 through 15 to 2 if the cells in column b (cells b20 to b25) are greater than the cells in column f (cells f10 to f15). Specifically, the row height of row 10 will be set to 2 if cell b20 is greater than f10:

See Table::setwidth, Table::setindent and Table::setjust for details on setting table widths, indentation and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where indent_arg is an indent value specified in 1/5 of a width unit. The width unit is computed from representative characters in the default font for the current table (the EViews table default font at the time the table was created), and corresponds roughly to a single character. Indentation is only relevant for non-center justified cells.

The default values are taken from the settings at the time the table is created.

The cell_range defines the cells to be modified. See Table::setformat for the syntax for cell_range specifications.

To set the justification, provide a valid cell specification:

See Table::setwidth, Table::setheight and Table::setjust for details on setting table widths, height, and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where format_arg may consist of the following:

The default settings are taken from the original view when created by freezing a view, or as “middle bottom” for newly created tables.

The cell_range defines the cells to be modified. See Table::setformat for syntax.

To set the justification, you must provide a valid cell specification:

See Table::setwidth, Table::setheight, and Table::setindent for details on setting table widths, height and indentation.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where cell_range describes the table cells to be modified, and line_args is a set of arguments used to modify the existing line settings. See Table::setfillcolor for the syntax for cell_range.

The line_args may contain one or more of the following:

draws borders around the outside of the rectangle defined by B2 and D6. Note that this command is equivalent to:

which adds borders to all of the cells in the rectangle defined by B2 and D6, then removes the inner horizontal and vertical borders.

puts a border around all four sides of the B2 cell.

then removes both the left and the right border from the cell. In this example, “+i” option has no effect; since the specification involves a single cell, there are no inner borders.

removes all borders from the table.

See Table::settextcolor, Table::setfillcolor, and Table::setfont for details on changing text color and font.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table Objects” for a discussion and examples of table formatting in EViews.

where cell_range describes the table cells (in a single row) to be merged. The cell_range specifications are given by:

If the first specified column is less than the last specified column (left specified before right), the cells in the row will be merged left to right, otherwise, the cells will be merged from right to left.The contents of the merged cell will be taken from the first non-empty cell in the merged region. If merging from left to right, the left-most cell contents will be used; if merging from right to left, the right-most cell contents will be displayed.

If you specify a merge involving previously merged cells, EViews will unmerge all cells within the specified range.

merges the cells in row 2, columns 1 to 4, from left to right.

merges the cells in row 2, columns 2 to 5, from right to left. We may then unmerge cells by issuing the command using any of the previously merged cells:

unmerges the previously merged cells.

Note that in all cases, the setmerge command must be specified using cells in a single row. The command:

generates an error since the cell specification involves rows 2 and 3.

See Table::setwidth, Table::setheight and Table::setjust for details on setting table widths, height, and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table Objects” for a discussion and examples of table formatting in EViews.

where prefix is the prefix you wish to assign to the cells. To remove a prefix from a cell, leave prefix empty.

The cell_range defines the cells to be modified. See Table::setformat for the syntax for cell_range specifications.

prepends the dollar sign ($) to the cell A1.

removes the prefix from cell A1.

See Table::setwidth, Table::setindent and Table::setjust for details on setting table widths, indentation and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where suffix is the suffix you wish to assign to the cells. To remove a suffix from a cell, leave suffix empty.

The cell_range defines the cells to be modified. See Table::setformat for the syntax for cell_range specifications.

appends the dollar sign ($) to the cell A1.

removes the suffix from cell A1.

See Table::setwidth, Table::setindent and Table::setjust for details on setting table widths, indentation and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where cell_range describes the table cells to be modified, and color_arg specifies the color to be applied to the text in the cells. See Table::setfillcolor for the syntax for cell_range and color_arg.

To set an orange text color for the cell in the second row and sixth column of TAB1, you may use:

You may also specify a blue color for the text in an entire column, or an entire row,

or a green color for the text in cells in a rectangular region:

You may also conditionally set the text color for a range of cells. For example, cell d3 will be set to red if cell b4 plus c4 is greater than cell d4 minus e4, and similarly for cells d4 to d18.

This also works for fixed columns and rows. To set the text color for the cells a13 to b18 to red if the matching cells from the fixed column B (cells b4 to b9) are greater than 0.5:

This sets the text color for the cells e13 to f18 to orange if the matching cells from fixed row 4 (cells b4 to c4) are greater than 0.5. Specifically, the text color of cells e13 through e18 will be orange if cell b4 is greater than 0.5, and the text color of cells f13 through f18 will be orange if cell c4 is greater than 0.5:

See Table::setfont and Table::setfillcolor for details on changing the text font and cell background color.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

where col_range is either a single column number or letter (e.g., “5”, “E”), a colon delimited range of columns (from low to high, e.g., “3:5”, “C:E”), or the keyword “@ALL”, and width_arg specifies the width unit value. The width unit is computed from representative characters in the default font for the current table (the EViews table default font at the time the table was created), and corresponds roughly to a single character. width_arg values may be non-integer values with resolution up to 1/10 of a width unit.

sets the width of column 2 to 12 width units.

sets the widths for columns 2 through 10 to 20 width units.

You many conditionally set the column width. This will set the individual column widths of columns c through e to 5 if the cells in column b are greater than 0.5. Specifically, the width of column c will be set to 5 if cell b20 is greater than 0.5:

See Table::setheight, Table::setindent and Table::setjust for details on setting table height, indentation and justification.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See also “Table and Text Objects” for a discussion and examples of table formatting in EViews.

displays and prints table TAB1.

where column_arg is a list of columns by which to sort the cell_range. You may specify up to three columns for sorting. The specified columns must be within the cell_range. If you list two or more columns, sort uses the values of the second column to resolve ties in the first column, and values of the third column to resolve ties in the first and second. By default, EViews will sort in ascending order. To sort in descending order, precede the column name with a minus sign (“-”).

The cell_range defines the cells to be modified. See Table::setformat for the syntax for cell_range specifications.

sorts the cells from the 1st column 1st row to the 3rd column 20th row by column b in ascending order.

sorts the cells from the 2nd column 10th row to the 26th column 250th row by column f in descending order, then in ascending order by column h and once again in ascending order by column q.

See Table::setformat for the syntax for cell_range specifications.

The table command declares and optionally sizes a table object. When used as a table view, table displays the contents of the table.

The table command takes two optional arguments specifying the row and column dimension of the table, and is followed by the name you wish to give the matrix. If no sizing information is provided, the table will contain a single cell.

You may also include an assignment in the sym command. The symmetric matrix will be resized, if necessary. Once declared, symmetric matrices may be resized by repeating the sym command with new dimensions.

The table view displays the contents of the table. It is a synonym for sheet.

declares a one element table

creates a table OUTTABLE with 10 rows and 5 columns.

See also freeze and Table::sheet.

For additional discussion of table commands see “Working with Tables and Spreadsheets”.

See “Table and Text Objects” for a general discussion and examples of table formatting in EViews.

where title_arg is a case sensitive string which may contain spaces.

sets the TAB1 title to “Estimated Models.”

clears the TAB1 title.

See also Table::displayname and Table::label.

where cell_range can take one of the following forms:

To rotate the cells in column 1 to row 1 in table TAB1:

To rotate all of the cells in TAB1:

To rotate the cells in range B11:C20 to range B11:K12: