Statistics Canada - Statistique Canada
Skip main navigation menuSkip secondary navigation menuHomeFrançaisContact UsHelpSearch the websiteCanada Site
The DailyCanadian StatisticsCommunity ProfilesProducts and servicesHome
CensusCanadian StatisticsCommunity ProfilesProducts and servicesOther links

Warning View the most recent version.

Archived Content

Information identified as archived is provided for reference, research or recordkeeping purposes. It is not subject to the Government of Canada Web Standards and has not been altered or updated since it was archived. Please "contact us" to request a format other than those available.

63-008-XIB
Wholesale Trade
November 2002


Viewer Frequently Asked Questions
Our unique table viewer picks up where your Web browser leaves off. Using Statistics Canada's own table viewer, you can:

Obtain Statistics Canada's table viewer free of charge. Get it NOW!

If you need help using the table viewer, please contact us.


How do I isolate specific rows and columns?

  1. Click on the "Table" menu
  2. Select "Rows" (or "Columns")
  3. Double click on the plus sign to expand or double click on the minus sign to minimise the hierarchy
  4. You can deselect an item by clicking on the check mark or you can select an item by clicking on the circle, selected items will appear in the table view
  5. When selecting rows, the "Check children" option controls the behaviour of the select/deselect action. When "Check children" is enabled (default), selecting an item will also select every item contained within the item being selected (the same is true for deselecting). This gives us a handy way of deselecting everything by deselecting the top most item. Then, only items of interest can be selected for viewing.

To display the table in its original form (i.e. all columns and rows are selected), choose "Reset" from the "Table" menu

Note: a check mark beside an item means the item has been selected and a circle beside an item means the item has been deselected.

Top of Page


How do I export data to a spreadsheet?

  1. Click on the "File" menu
  2. Select "Export"
  3. Indicate the location you would like to save in
  4. Give your file a name
  5. Choose a file format for exporting from the drop down menu titled "Save as type"

The export function provides an option to convert the tables into different file formats. The file formats supported by the export function are:

File Format Comments
HTML

Converts tables into HTML format, which can be viewed by Internet browsers.

Note: When converting into HTML format, the full table will be exported. The export will not be affected by any customisations.

Excel

Converts tables into Excel version 4.0 or 5.0

Note: If you customised your table using the columns and rows functions, the export function will extract only the data found in your customised table view.

Tabbed-Text (Values only)

Converts tables into a tabbed-text format.

Note: If you customised your table using the columns and rows function, the export function will extract only the data found in your customised table view.

Top of Page


How do I use print options to customise printing?

From the "File" menu, select "Page Setup..."

Create custom headers and footers

In the Header and/or Footers box enter your text.

Note: you can only have one custom header and one custom footer on a table. If you create a custom header or footer, it will replace any existing header or footer on the table.

Set page margins

In the Top, Bottom, Left and Right boxes, enter the desired margin size

Note: the measuring units for the page margins can be set to inches or centimetres

Grid Line By default the grid lines option is always on and cannot be changed.
Black and White By default the black and white option is always on and cannot be changed.
Row Heading Prints the row headings on the left side of the table
Column Heading Prints the column heading at the top of the table.
Scale

Enter the percentage by which you want to reduce or enlarge the table, or you can tick the "Fit to page(s)" box to fit the table to the page.

You can use the "Pages Wide" and "Pages High" to span the table across one or more pages.

Top of Page



Home | Search | Contact Us | Français Return to top of page
Date Modified: 2004-04-28 Important Notices
Contents Highlights Tables and charts Data quality User information Products and services PDF version