Overview
Before saving the results, consider shaping up the data as you need present. At a first step, check and process the contents.
- table sort rows() to sort tables by alphabetic, numeric, date orders, etc.
- table sort columns() to sort columns.
- table rearrange columns() and table rearrange selected rows() to move the data into the right locations, e.g. most important data to appear on the top left.
- table substitute horizontally() and table substitute vertically() to replace repeating values with a simple remark.
If you plan to save the work in Excel (or HTML), then consider adding styles such as applying colors, different typefaces, freezing the header row, adjusting column width, applying autofilters, etc.
- table style auto width() will adapt the column widths based on the lengths of the contents.
- table style theme() applies a graphic theme on the table, e.g. highlighted header row and zebra pattern in the rows below for better readability
- table style table() to apply further formatting, e.g. setting an autofilter feature on the header row or freezing top rows or left columns
- table style rows(), table style columns(), ad table style cells() to apply specific formats and colors on specified table locations.
Wikipedia Example (continued from step 6)
Do some validation on this table:
- Apply a theme "Zebra" (interchanging white and field color patterns)
- Autowidth, but at least 12 Excel width units wide
- Set autofilter on header row and freeze it
Simple Example
table style theme ( countries, Zebra, pattern, 2 );
table style auto width ( countries, min, 12 );
table style table ( countries, sheet, freeze rows, 1, autofilter, 0 );
echo("Formatting done.");The table has been formatted.
Formatting done.