Automated Solutions Logo

Excel Add-in for PLC and Instrument Connectivity
Get Allen-Bradley, Siemens S7, GE PACSystems, and Modbus Data Into Excel Spreadsheets.

No OPC, DDE, external drivers, or programming required


Product Summary


ASComm Excel Add-in is a simple to use, non-programmatic way to populate Excel 2007 - 2016 spreadsheets with data from PLCs, instrumentation, and other process hardware.

ASComm Excel Add-in uses ASComm.NET to perform communications, so you can easily configure the ASComm Excel Add-in to populate an Excel spreadsheet with data from Allen-Bradley, Siemens, GE-IP, Modbus/TCP and Modbus RTU controllers.


Download 30-day Trial


 

ASComm.NET Excel Add-in

 

How it Works

 

To get started, use our Runtime Configuration Application to visually create a portable ASComm.NET configuration file (devices, data points, etc.) and save the configuration for later use.

1.1. Create a new configuration or open an existing configuration file using our Runtime Configuration application.

Use File> New to create a new configuration file.

Use File> Open... to open an existing configuration file.

1.2 Create Channels, Devices, Groups, and Items using the toolbar buttons and associated dialogs.

Runtime Configuration Application

1.3. Save the configuration file using File> Save (or File> Save As...)

Once you have created the configuration file, you can run it inside the Runtime Configuration Application to verify proper configuration. To read values, select the Group that you would like to monitor, then click the Value View toolbar button. To write values, select the Item in the list view, then click the Write toolbar button to bring up the Write Values Dialog.

For more advanced applications (branded, database, etc.), you can build your own configuration application that utilizes ASComm.NET's configuration and serialization capabilities.

NOTE: Step 2 only needs to be perfomed once. If you have already added ASComm.NET Excel Add-in to Excel, proceed to Step 3.

These instructions describe Excel 2013 configuration. Excel 2007 and 2010 dialogs may be slightly different, but the steps are the same.

2.1. Create a new Excel notebook.

2.2. Add the ASComm.NET Excel Add-in to Excel Add-ins.

In Excel, select File> Options> Add-ins

Excel Add-ins

At the bottom of the dialog, in the Manage dropdown list, choose 'COM Add-ins', then click the Go... button.

Select ASCommExcelAddIn1 from the COM Add-ins dialog, then click the OK button.

COM Add-ins

 

3.1 Locate the ASComm.NET tab on the Excel ribbon

Excel AddIn Ribbon


3.2 Click the 'Show' button in the Task Pane group to show the ASComm.NET Task Pane.

Excel AddIn Show Task Pane Button


3.3 Select the ASComm.NET configuration file created in Step 1 (above).

Excel AddIn Show Task Pane Button


3.4 The Configured Items list box will now show the configured items.

Excel AddIn Show Task Pane Button


3.5 Configure ASComm.NET data collection, data storage, and error handling parameters for this spreadsheet using the task pane.

Excel AddIn Show Task Pane Button


 

Data Collection

Run When Workbook Opens

This option causes ASComm.NET Excel AddIn to automatically start when a workbook is opened

Update Rate

This sets the logging update rate in milliseconds. This is the rate at which rows are added to the spreadsheet, not that rate that data is collected from target devices.

To configure data collection rate, refer to configuration application in Step 1, specifically Group UpdateRate property.

Clear Sheet on Run

Clears sheet data when Run button is pressed or workbook is opened and 'Run When Workbook Opens' is checked.

Reset Record Number on Run

Resets record number when Run button is pressed or workbook is opened and 'Run When Workbook Opens' is checked.

 

Data Storage

Add Timestamp

Adds a timestamp column before data columns.

Add Record Number

Adds a record number column before data columns.

Sheet Name

Allows you to specify a sheet within the current workbook to log to.

Starting Cell

Allows you to specify a cell (A1, BC10, DEF21, etc.) that will be the starting row and column for logging.

Mode

  • Logging (new row for each update)

    Adds a new row for each record.

  • Real time (Single row for all updates)

    Overwrites previous record on a single row.

 

Diagnostics

Output to Windows Event Log

This option causes ASComm.NET Excel AddIn to output errors to the Windows Event Log.

Spreadsheet Error Text

Allows you to specify text to be logged when data is invalid.

Error Color

Allows you to specify text color to be logged when data is invalid.

Excel AddIn Ribbon

 

Manual Start

To start data logging, select the ASComm.NET ribbon tab, then click the Run button

Alternate VBA method

Sub ButtonStart_Click()
  On Error Resume Next

  Set addin = Application.COMAddIns("ASCommExcelAddin")
  Set automationObject = addin.Object
  Call automationObject.Start
  Exit Sub 
End Sub           

 

Stop

To stop data logging, select the ASComm.NET ribbon tab, then click the Stop button

Alternate VBA method

Sub ButtonStop_Click()
  On Error Resume Next

  Set addin = Application.COMAddIns("ASCommExcelAddin")
  Set automationObject = addin.Object
  Call automationObject.Stop
  Exit Sub 
End Sub           

 

Automatic Start

To start data logging when workbook opens, click the Run When Workbook Opens checkbox (described in Step 3).

 

On-demand

ASComm Excel Add-in can read data from hardware devices and populate Excel spreadsheets without writing any code.

In order to perform on-demand logging a small amount of VBA code is required.

Example

Excel AddIn On-Demand Logging

 

To generate an on-demand log entry when ButtonReadAll is clicked:

Sub ButtonReadAll_Click()

  On Error Resume Next

  Set addin = Application.COMAddIns("ASCommExcelAddin")
  Set automationObject = addin.Object
  Call automationObject.ReadAll
  Exit Sub
  
End Sub
                  

ASComm Excel Add-in can read data from hardware devices and populate Excel spreadsheets without writing any code.

In order to write data to hardware devices a small amount of VBA code is required.

Example

Excel AddIn Manual Start

 

To write the value from spreadsheet 'Sheet1' cell 'L9' to the Item specified in cell 'L6' when ButtonWriteValue is clicked:

Sub ButtonWriteValue_Click()
  On Error Resume Next
  Dim item As String
  Dim value As String

  ' Obtain Item name from cell 'L6' in spreadsheet
  item = Sheet1.Range("L6")
  ' Obtain value from cell 'L9' in spreadsheet
  value = Sheet1.Range("L9")

  Dim addin As Office.COMAddIn
  Dim automationObject As Object
  Set addin = Application.COMAddIns("ASCommExcelAddin")
  Set automationObject = addin.Object
  Call automationObject.WriteValue(item, value)
  Exit Sub
End Sub
                  

Licensing

 

ASComm.NET Excel Add-in requires one Single Machine license for each configured driver per PC that the Excel Add-in will run on.

Unlike applications built using Visual Studio, Office applications do not have the mechanism required to embed a runtime license using ASComm.NET Full Development license. That is why a Single Machine license is required on each PC that will run ASComm Excel Add-in.

For example, to run ASComm.NET Excel Add-in with the Allen-Bradley ControlLogix Ethernet driver on five PCs, you would purchase an ASCOMM-AB.LOGIX.NET-SM-5 five license package for $996. Use License Manager to activate the licenses on each PC. That's it!

Refer to ASComm.NET Product Page, select driver or driver suite, the go to the Catalog Information section and select the Single Machine License button for purchase options and pricing.

 

Compatibility

Excel Versions

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007

Platform

  • Requires .NET framework 4.0 or higher

Operating System

  • Windows 10
  • Windows Server 2012
  • Windows Server 2008
  • Windows 8.x
  • Windows 7
  • Windows Vista