SIMUL8 logo

Excel Connections

With the Excel Connections feature, you are able to import and export data and results in just a few clicks.

You will find the Excel Connections on the Data and Rules tab. Select Excel Connections and a window containing a list of all connections will appear. From this menu, you can create, edit and erase Excel Connections, and use this window to perform the actual import and export of data.

New Connection

From the Excel Connections window, select New; this will open the Excel Connection Properties window. This is where you will set up the link to Excel.

Use the Browse… button to search for the Excel file you wish to use for importing/exporting data. When this file has been chosen, SIMUL8 will automatically look into Excel and generate the sheet names so that you may select the sheet you want to reference from the dropdown. When you select an Excel sheet, SIMUL8 will automatically calculate the area that is populated by data.

The Internal Spreadsheet Settings determines what SIMUL8 spreadsheet you are using for importing/exporting. You can use the New button to create a new internal spreadsheet directly from the Excel Connections Property menu.

The Data Flow section determines the flow of data, whether you are moving from SIMUL8 to Excel, or Excel to SIMUL8.

You can also choose to clear the spreadsheets before import/export.

Advanced Settings

On the Advanced Settings tab, you can specify a data range for both the Excel Spreadsheet (on import) and Internal Spreadsheet (on export).

Once you have created your connection, choose OK to see your connection on the list.

Excel Connections List

Select the connection and click the Import/Export button to transfer the data.

For ease of use, once you have created connections, you can import/export multiple connections at once.

To do this, navigate to the Data and Rules tab, and select Import All or Export All on the Microsoft Excel Connections section. The dropdown on each also allows you to import or export a specific connection without having to open the connections menu.

See Also

logo
cleardot