01 Basic Usage

Basic Network

The basic table contains two columns, From and To, which represent network nodes. Each row in the table corresponds to a link or edge between two nodes. The direction of the link goes from the node in the From column to the node in the To column. Column names may be written in either uppercase or lowercase.

1. Create table with columns From-To and select range.

2. Select table range.

3. When range is selected press Select Range button.

4. After press Build Network button.

5. Network visualization will opens in a generated HTML file.

6. Duplicate rows are aggregated by summing their occurrences. For instance, the A–B link appears twice, resulting in a value of 2.

7. By default, the file is saved in your machine's temporary folder with the name VisjsNetwork.html.

Basic Network Data Table

To avoid manually typing the columns, you can use predefined data tables with the correct structure.

1. Click on the Data Tables button to display a dropdown list. This list shows all available combinations of table structures that can be used to build a network.

2. Select "From-To Table," and a window will pop up asking where to place the table. Additionally, clicking the "Data Tables" button will, by default, generate the From-To Table.

3. Press OK and Excel table will be generated with columns From and To.

Output folder and generated network file name

Define the location of the output folder and the HTML file name for the generated network visualization.

1. Set output folder by pressing Output Folder button.

2.Set the network HTML file name by selecting Network File Name in the Network Settings.

3. If you set a new output folder and file name, the configuration will be saved, and these settings will persist the next time you open Excel.

Ensuring HTML File Data Integrity.

A TXT file containing the SHA-256 hash of the HTML content will be generated alongside the HTML file to verify its integrity. This TXT file will be saved in the specified output folder and will share the same name as the HTML file.

The TXT file will contain information about the iExcelNetwork version, the network file name, the SHA-256 hash, and about project.

Basic Network with Count column

1. Let's paste the same data from the Basic Network and assign values to the Count column. Count column accepts only integers!

2. This will produce the following network:

3. You can observe that Count column values were summed in the case of duplicated rows.

Basic Network with Link Confirmation

A Basic Network has Link is Confirmed column with dropdown values TRUE and FALSE.

1. Let's paste the same data from the Basic Network and assign values to the Link Is Confirmed column.

2. This will generate a network where dashed links represent unconfirmed connections.

3. Please note that you will get error if duplicated rows has different values of Link Is Confirmed column.