Display Excel 365 within GoBright View

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 within Windows won’t work, please follow these steps:
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 (that is the “My Files” 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 – Make sure this matches with the sheet in your Excel file, otherwise View will show an error message.
   9. Range – This affects which and how many rows and columns will be displayed in the widget. You may select a smaller range if you want to display less columns or rows.
9. The other parameters can be used to change display settings such as colours
   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

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