# Using OneVision with In-Sight Spreadsheet

OneVision supports an In-Sight Spreadsheet integration, which allows you to import and manage your OneVision toolchains as part of your spreadsheet jobs. You can upload images directly from In-Sight Spreadsheet to OneVision, build and train your toolchain Contains a group of tools and the sequence of execution for each tool. in the browser interface of OneVision, then sync data back to the spreadsheet.

The basic workflow consists of simple tasks such as creating new projects from the spreadsheet, loading an existing project In OneVision, a project is a collection of images and vision tools that performs different tasks, such as inspection, measurement, or identification., or uploading images from the spreadsheet to OneVision. The workflow always starts with adding a Toolchain function to the spreadsheet and using its Property Sheet to log in to OneVision. From the Property Sheet, you can access a range of options that allow you to manage your projects and deploy them in spreadsheet.

How to connect to OneVision from spreadsheet

You can connect OneVision with In-Sight Spreadsheet using the ToolchainContains a group of tools and the sequence of execution for each tool. function. After adding the function to the spreadsheet, you need to sign in with your OneVision account. Once authentication is complete, you can access several options in the spreadsheet, such as creating a new OneVision projectIn OneVision, a project is a collection of images and vision tools that performs different tasks, such as inspection, measurement, or identification., uploading images to a project, or exporting a project into the spreadsheet.

To connect OneVision to In-Sight Spreadsheet:

1. Drag-and-drop the Toolchain function from the In-Sight Toolbox to the spreadsheet or type toolchain( into one of the cells. The Toolchain property sheet pops up.

2. In the Property Sheet, select the host you want to connect to in the Host Region dropdown.

3. Click Login and enter your OneVision credentials in the authentication window.

4. Click Continue.

The authentication window automatically closes after a successful sign-in and the User field in the Property Sheet shows your username.

After logging in, you have the following options to start working with OneVision in In-Sight Spreadsheet:

- Create a new OneVision project.

- Open an existing project in the OneVision browser interface.

- Select a project and add it to the spreadsheet cell. This connects the cell to the Input ImageThe set of images used to train and test your vision application. tool in OneVision.

How to transfer images from spreadsheet

You can use images from In-Sight Vision Suite in your OneVision projectIn OneVision, a project is a collection of images and vision tools that performs different tasks, such as inspection, measurement, or identification.. Using the ToolchainContains a group of tools and the sequence of execution for each tool. function in spreadsheet, you can collect, tag, and transfer images from the Filmstrip or from live image acquisition. The image collection method is similar to collecting images with the ViDiEL tools.

You can access the image collection from a file explorer if needed. The images are stored locally on the vision sensor and they are deleted after you upload them to OneVision.

Before you start, ensure that the Filmstrip contains images.

To transfer images from In-Sight Vision Suite:

1. Add a Toolchain function to the spreadsheet.

2. In the Property Sheet of the Toolchain function:

   1. Log in to OneVision.

   2. Select a project in the Project dropdown.

   3. Check the Collect Images checkbox.

   4. Click OK to close the Property Sheet and apply your changes.

3. Load images from the Filmstrip into the Toolchain function.

   - To add images one by one, double-click the desired images in the Filmstrip.

   - Click the Play button in the Filmstrip controls to load all of the images in the Filmstrip.

   - The Num Images field of the Toolchain function indicates the number of images in the collection.

   - Once you have loaded the images, uncheck the checkbox in the Collect Images cell of the function.

4. Review the images in the collection.

   1. Open the Property Sheet of the Toolchain function and go to the Images tab.

   2. To help you manage your image collection, add tags to your images. The tags are uploaded to OneVision together with the images.

   3. Delete duplicate or unneeded images from the collection.

5. To upload the images to OneVision, click Upload Images in the Property Sheet of the Toolchain function.

Note: If you collect images but do not upload them, the images can stay in the storage of the vision sensor, taking up storage space.

To verify that the images are available in OneVision, open the Input ImageThe set of images used to train and test your vision application. tool in OneVision and check the images.

How to export a toolchain into spreadsheet

Once you have a trained toolchainContains a group of tools and the sequence of execution for each tool. in OneVision, you can export the toolchain and its results into In-Sight Spreadsheet. The exported toolchain does not contain images.

To export the toolchain into In-Sight Spreadsheet:

1. In In-Sight Spreadsheet, open the Property Sheet of the Toolchain function.

2. Log in to your OneVision account if you are not already logged in.

3. Select a projectIn OneVision, a project is a collection of images and vision tools that performs different tasks, such as inspection, measurement, or identification. in the Project dropdown.

   - This automatically syncs the latest version of the toolchain with spreadsheet.

   - Optional: To work with an earlier version, select a version in the Version dropdown.

4. Click OK to close the Property Sheet.

Closing the Property Sheet automatically adds the default getters to the spreadsheet. If needed, you can manually add the default getters by right-clicking the Toolchain function and selecting Insert Getters from the context menu.