You are here: Products and Services Canary Excel Add-In
E-mail Print PDF

Canary Excel Add-In

The Canary Excel Add-In gives Microsoft Excel the capability of access data from the Canary Enterprise Historian. It does this by using the Add-In capability built into Excel. Add-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core functionality, while others allow third-party products to add features to Excel's environment.

When you install the Canary Excel Add-In, you can set it up so that it will be loaded automatically each time Excel is opened. A sample worksheet is included that shows how to use the additional functions provided by the Canary Excel Add-In.

The functions provided are:

  1. CanaryGetAggregates
  2. CanaryGetDataSetInfo
  3. CanaryGetDataSetList
  4. CanaryGetProcessedData
  5. CanaryGetRawData
  6. CanaryGetServerInfo
  7. CanaryGetServerList
  8. CanaryGetTagCount
  9. CanaryGetTagList
  10. CanaryGetTagProperties
  11. CanaryVersion

Some typical applications for the Canary Excel Add-In are custom Excel reports, Excel graphs and custom displays. With this Add-In, it is easy to bring data into Excel worksheets.

" Managers and engineers now can see things that before were a mystery.  Sometimes operators would forget to do something or simply do something wrong.  When the product quality failed, often we could not pinpoint the reason since it showed up long after the cause of the problem.  Now we can historically trace the product back through time and determine the cause.  This knowledge can now be used to build safe guards to improve our products quality. "

John Ball, Assistant Process Control superintendent, Canadian Forest Products