Rockwell Automation FactoryTalk Historian Classic User Guide - Manual (Page 97)

Chapter 6
Advanced Reporting Topics
In this chapter you will learn about the following:
• The Excel Add-in 97
• Scheduling Report Objects and Reports 101
• Analyzing Non-RSBizWare Data 110
The Excel Add-in allows you to retrieve RSBizWare data (general
reporting or grid data, and time-series data) directly in Microsoft
Excel. After the RSBizWare data has been imported into Excel, you
can use any of Excel’s analysis, charting, or scripting features to
further process the data.
When you install the RSBizWare software on a computer, a custom
RSBizWare toolbar is added to Microsoft Excel. The toolbar allows
you to perform the tasks necessary to retrieve the RSBizWare data.
To specify the Excel and Information Services Manager
connectivity settings:
1. On the RSBizWare toolbar, click to display the
RSBizWare Connectivity Settings dialog box.
The Excel Add-in
Rockwell Automation Publication HIST-UM001K-EN-E-June 2014 97