First Steps

OctoMesh provides an Excel add-in that allows you to interact with your data in Excel.

We provide the following features in the Excel add-in:

• Query: Based on an OctoMesh System Query, you can query data from your OctoMesh system, insert or update the data in Excel, and push the changes back to the OctoMesh system.
• Insert: We have implemented several import algorithms to import Tree data from Excel from standard work sheets.
• Enums: Manage data of dynamic enums by inserting enum data and modify it.

Installation

The Microsoft Office Manifest file defines the add-in and its settings. The manifest file is used to install the add-in in Microsoft 365 Admin Center or to side-load the add-in locally. To download the manifest file, follow these steps:

1. Go to the Website of the OctoMesh Add-In, located at https://office.{domain}.{tld} (Replace the placeholders {domain} and {tld} with the domain and top-level domain of your OctoMesh instance).
2. Click on the "Download" button to download the manifest file or copy the URL to the manifest file.
3. Follow the steps from Microsoft to register the Add-In in Microsoft 365 Admin Center.

To install the OctoMesh Excel add-in, follow these steps:

1. Open Excel.
2. Go to the Start tab.
3. Click on the Office Add-ins button and select tab "Managed by your organization".
4. In the Office Add-ins dialog, search for OctoMesh.
5. Click on the Add button to install the OctoMesh add-in.

Install the add-in locally using side-loading or from a network share

To install the add-in locally using side-loading or from a network share

• Side load an Office Add-in from a network share on Windows
• Side load an Office Add-in from a network share on Mac

Getting Started

After installing the OctoMesh Excel add-in, you can start using it by following these steps:

• Open Excel.
• Click on the OctoMesh tab.
• Click on the "Connect" button to connect to your OctoMesh system.
• Enter your OctoMesh Admin Panel URL, enter a valid name of your tenant and click on the "Connect" button.
• After connecting to the OctoMesh system, you can start querying data from your OctoMesh system.

Features

• Query: Query data from your OctoMesh system, using an OctoMesh System Query.
• Insert: Insert data into your OctoMesh system, using different importer types
• Enums: Edit dynamic enums in your OctoMesh system.