Artemis for Excel: Getting Started

Written By Charles Black

In this post, we’ll go over how to get setup with Artemis for Excel.

Note: In order to utilize Artemis for Excel (AE), you will first need your Artemis Tenant Domain and API Key. Please contact Oscillas Support if you haven’t been issued these credentials.

Installation

  1. Option A - Quick Install: Go to Microsoft AppStore

  2. Option B - Manual Install:

    1. Open Microsoft Excel

    2. Click on the Add-ins button in the ribbon

    3. Click More add-ins

    4. Search for “Artemis Cloud”

    5. Click Add on the Artemis Cloud Connector add-in

Authentication

  1. Navigate to the Data tab of the ribbon

  2. Click on the Artemis icon (the deer), a sidebar on the right-pane will open

  3. In the sidebar, click Get Started!

  4. Enter your Artemis Tenant Domain and API Key

  5. Click Authenticate

Usage

List Database Reports

This function outputs all of the report names that are available to you.

  1. Function: =artemis.list_database_reports()

  2. Output: A list of report IDs and Names that are available to your user. You can utilize the Name field as an input to the Run Database Report function below.

Run Database Report

This function allows you to retrieve any of the reports that are available to you by name.

  1. Function: =artemis.run_database_report({report_name})

  2. Example: =artemis.run_database_report(“test_report”)

  3. Output: The columns and rows of the report you named in the first (and only) argument of the function.

Charles Black