Create Table of Contents

Key Steps

To create a Table of Contents from an existing workbook, follow the steps below.

Step #

Step Detail

1

Click on the “ToC” button in the TableWiz Menu bar.

2

A parameters form is activated (See Figure below)

3

Fill in the parameters and/or accept the defaults generated by TableWiz based on the selected schema. Refer to the Parameter Description Table below.

5

When ready to create the datagrid(s) from the loaded schema, click on the “Go” Button

6

The function will complete.

7

If you want to retry the function, go to step 3

8

Else, click in the X button to close the parameter form

Table 7: Create a Table of Contents Steps

Parameters

The following dialog / form appears, containing the parameters required to create a Table of Contents.

Figure 21: Create Table of Contents Parameters Form

The table below describes these parameters in more detail.

Section

Property Name

Description

Data Type

Input Parameters

 

These parameters define the schema that will be used to create the table or range output

 

Result Settings

 

These parameters control the layout of the new table/range and select the target Excel container in which the new table/range is created

 

Result Settings – Result Content

 

These parameters control the layout of the new table/range

 
 

Table/Range Selector

Select whether the target will be created as a range or as an Excel Table.

 
 

Add Border around range

with Excel Tables, formatting is created by Excel, but with Range target Tablewiz can create a simple border around the range.  If format metadata was captured and stored in the schema, the schema metadata will override this setting

Checkbox

 

# Rows

Defines the number of table rows to create. If table size metadata was captured and stored in the schema, the schema metadata will override this setting

Integer

 

Add dummy data

Leave unticked if the result should just be the empty table structure.  Check this if you want dummy data to be created in the result table or range

Checkbox

Result Settings – Target Location

 

These parameters select the target Excel container in which the new table/range is created

 
 

Target Workbook

if you want to create a new Workbook, select “New” in the drop-down selector.  Otherwise select an open workbook in which you want to create this new table.

 
 

Target Worksheet

if you want to create a new Workbook, select “New” in the drop-down selector (default).  Otherwise select one of the existing worksheets in the selected workbook in which you want to create this new table.

 
 

Target Address

the source address is captured by TableWiz when the schema is created.  This setting will be used to populate these settings in the parameter form, but you can modify this by editing either the target address or the row/column numbers.  it’s entirely your preference which you edit as changes in one are reflected in the other.

 

Table 8: Create Table of Contents Parameters Reference