Illustration

Excel 365

This widget is able to get a specific Excel file from OneDrive and display it within GoBright View. It retrieves information from a specified sheet and a set range.

Before you begin…

This widget makes use of the Microsoft Graph API which is a way to get information from Office 365 to GoBright View. If this is not setup yet this needs to be configured by an Azure admin first. Please follow this article: Graph API

The Excel file needs to be shared with the service account or needs to be owned by the service account. This service account is then used by the GoBright Excel widget to access the file.

Within OneDrive

First: determine if the file should be shared with or owned by the service account. Pick whatever works best in your situation, but carefully read the next steps:

If the file is shared with the service account:

  1. Open a browser and go to onedrive.com. Sharing the file from Windows won’t work.
  2. Log in with your own user account (not the service account)
  3. Locate or create the Excel file that needs to be displayed in GoBright View
    1. Right click the file
    2. Select Manage Access
    3. Under Direct Access, add the email address of the service account
    4. Untick Notify people (optional)
    5. Click Grant access

If the file is owned by the service account:

  1. Open a browser and go to onedrive.com
  2. Make sure the file is in the root folder

To make sure the service account has access to this file:

  1. Open an incognito window (or log out from OneDrive)
  2. Go to onedrive.com
  3. Log in with the service account
  4. Go to the ‘Shared’ folder
  5. Under ‘Shared with you’ the Excel file should be visible. If not, GoBright View won’t be able to access the file. Please try sharing the file again by repeating the steps above.

If the Excel file is visible you can continue to the next part of this guide.

Within GoBright View

  1. Go to portal.gobright.cloud
  2. Log in with your GoBright account and open the GoBright View portal
  3. Create a template or slide
  4. Click + Add widget
  5. Click Custom widget
  6. Select the Excel widget
    If you don’t see the widget in your View environment, please contact your GoBright partner.
  7. Click Done
    The Excel widget should now be added to the slide
  8. Fill in the parameters with the information provided by your Azure admin:
    1. Tenant ID
    2. Client ID
    3. Client Secret Value
    4. File Owner
      If the file is shared with the service account: select External Account
      If the file is owned by the service account: select Service Account
    5. Email address of the service account
    6. Password of the service account
    7. File name of the Excel file
    8. Sheet name
    9. Range
  9. The other parameters can be used to change display settings such as colors
    The data of the Excel file should now be visible
  10. Save the slide or add the template to a playlist
  11. Go to the Scheduling tab
  12. Click Update content

That’s it. The data from the Excel file should be visible on your GoBright View displays.

Troubleshooting

If the widget does not show any data or throws an error:

  • Make sure the service account has access to the file by logging in to OneDrive with the service account and check if the file is in the right location
  • Check if all parameters are set correctly

Starting august 2022, this configuration is no longer supported. We have updatet the GoBright View widgets accordingly. If you are still using an older widget and want to migrate please contact our support team.

There are five pieces of information that are required besides the connection with the Graph API:

  • The email address of the user that owns the excel file
  • (optional) the folder name and/or path (only if the file is not located in the users’ root folder)
  • The filename of the Excel document
  • The Sheet name
  • The range that should be displayed

mceclip0.png

These details need to be entered in the Widget parameters. Then the data should be visible in the widget.

This article comes from the Help Center of GoBright.
View original article
FAQ

Ask us anything! Find the answers to the most frequently asked questions here.

Browse the FAQ
Help center

A goldmine for all IT and Facility Managers. Dive into the technical stuff concerning our products and solutions.

Visit the help center
Newsletter

Wanna stay informed of all developments within the smart office and our new features? Subscribe now.

Subscribe now.