APIX.XL™

  1. Home
  2. Docs
  3. APIX.XL™
  4. APIX.XL™ User Guide
  5. Excel Ribbon and Advanced Features

Excel Ribbon and Advanced Features

Excel Ribbon

In addition to dynamic service functions and utility functions, APIX.XL™ comes with a new ribbon in Excel that can be accessed through the APIX.XL tab. Based on whether the user has a free or enterprise installation, buttons in the ribbon may differ.

Free-Installation Ribbon 

Enterprise-Installation Ribbon 

Common Buttons 
This section of the ribbon provides access to support, contact information, product release information, and the APIX.XL™ log file, which can be useful when investigating issues. 
 
Reload Button 
The Reload button allows the user to reload APIs as native Excel functions. 
 
Private Buttons 
This section of the ribbon enables the user to load and manage APIs. 
 
Manage API Auth Button 
 This button allows the user to manage API authentication settings. 
 
Quick Start Buttons 
This section of the ribbon enables the user to configure APIX.Hub™ or an API Gateway. 
 
Login/Logout Button 
If authentication is enabled, this button allows the user to log in against APIX.Hub™. 
 
Recalculate Buttons 
This section of the ribbon enables the user to quickly recalculate all functions in all workbooks open in the current instance of Excel or all functions in the currently selected workbook. 
 
Timer 
This section of the ribbon enables the user to automatically trigger recalculation on a worksheet for a certain time interval. 
 
API Versions Button 
This button allows the user to manage multiple versions of APIs. 

Additional APIX.XL™ Features

Handles for a Large Amount of Data 
When the amount of data returned by a service is too large to fit inside an Excel cell, the service data is stored in the workbook and a handle string is returned in the cell in its place. The cell can still be referenced by other utility functions normally, which will operate on the service as expected. 
 
Named Ranges 
Each of the render functions displays the data in the Excel range and also creates a named range for it. 

How can we help?