====== Excel Query Add-In ======

The Excel Query Add-In allows you to query your data sources directly from Excel. You can query data by using the "IP Data Query" tab or by writing data query formulas.

There are some instructional videos demonstrating how to use the Excel Add-In in [[https://www.youtube.com/playlist?list=PLsVwx5rtV9c0duV5jln2IX9BIMDCCEWrY|this playlist]].

You can download a spreadsheet containing examples of all the formulas [[https://appstore.intelligentplant.com/nuget/downloads/IP Excel Addin example.xlsx|here]].

===== Contents =====

  * [[excel:installation-files|Installation Files]]: Download and install Excel Query Add-in 32 or 64 bit 
 
  * [[excel:getting-started|Setup]]: Help installing, running, updating and uninstalling the add-in.

  * [[excel:ui|The IP Data Query Tab]]: Help using the data query tab.

  * [[excel:formulas|Writing Data Query Formulas]]: Help writing data query formulas.

===== Troubleshooting =====

Local logs are available in:

  {LOCALAPPDATA}/Intelligent Plant/Data Core/Excel/Logs/ExcelDataAddin.log