ScreenCloud Microsoft Excel App Guide

It’s now easier than ever to get any Excel sheet showing on your TV screens with the Microsoft Excel app. Use any spreadsheet from your OneDrive account to display for digital signage.

Feb 2019

ScreenCloud Microsoft Excel App Guide

Take control of using your Excel spreadsheets to display information, trends, and data across your digital signage screens with ScreenCloud’s Microsoft Excel app. You can easily connect your OneDrive account to begin choosing any excel spreadsheet and sheet tab, input a cell range to pull in specific data and display an optional Microsoft Excel logo and/or custom title to feature. Any updates made to your OneDrive spreadsheet will automatically update live on screen.

With the ScreenCloud’s Microsoft Excel app you can:

  • Select excel spreadsheets directly from your OneDrive account
  • Quickly configure the range of data from your spreadsheet to display live on screen
  • Add a custom title to display at the top of your spreadsheet

Here’s how it works:

1. Select and install ScreenCloud’s Microsoft Excel app

1.1. Get started by clicking here and selecting “Get App”. This will prompt you to either log into your existing ScreenCloud account, or sign up for our 14-day free trial in order to use the Microsoft Excel app and other available apps within our App Store.

1.2. Once you’ve logged in, you can select “Add this app” from the top right-hand corner.

2. Log in to OneDrive to select items

2.1. Next, click “Select Items” to log into your OneDrive account.

2.2. Log in using your OneDrive credentials to connect your account with ScreenCloud.

2.3. Select any Excel file from your OneDrive account. If it is within a folder, double-click to enter the folder and select the file. Then click “Select Workbook” in the lower right-hand corner to verify choosing this sheet.

2.4. Next, select the worksheet you’d like to choose from within your sheet. For example, if you have multiple tabs of data, you can select the exact tab from here you’d like to display on screen.

2.5. Click “Select WorkSheet” and you will now be redirected to the ScreenCloud app window where a green checkmark will appear next to “Select Items”. This verifies that your excel sheet is synced.

3. Configure your Microsoft Excel app

Next, you can configure the settings for your Microsoft Excel app.

i) Cell range: input the cell range based on your sheet for data you’d like to pull in. For example, if you want to show data on a sheet from A1 (the beginning of the sheet) all the way to B45, you would type in “A1:B45” here for this information to display.

ii) Toggle header: you can switch this on and off to display a Microsoft excel logo at the top of your spreadsheet, or use a custom title to display.

Toggle header = On

Toggle header = Off

iii) Sheet title: type in a custom sheet title that will display when you toggle the header on. If you leave this blank, a generic Microsoft Excel logo will appear in the header. Please note, the sheet title should contain no more than 25 characters. You will be alerted if you go over the maximum.

4. Preview your Microsoft Excel app

4.1. To preview your Microsoft Excel app, select “Preview App”. This will open a new window where you can see what your Microsoft Excel app will look like on screen.

Microsoft Excel App Guide - Toggle title:logo on 2.25.2019.png

4.2. If you need to select a new Excel file, click “Close Preview” to access your app settings. Once you’ve made any further changes, click “Save Changes” and return to open the preview.

5. Add Microsoft Excel app into your playlist

5.1. Once you’re happy with your settings, click “Add App” and give your Microsoft Excel app a name. This will help you to spot it later in your content library, particularly if you’re planning to use more than one Microsoft Excel app within your playlist.

5.2. Select “Finished” and your Microsoft Excel app will now be listed within your Content Library.

Please Note, If you want to edit your Microsoft Excel app at any time, you can simply hover over the app in the content library and choose “Edit This App”.
5.3. Next, select the playlist you wish to add this to and drag and drop the Microsoft Excel app from the right-hand side to the playlist of your choosing.

5.4. Here, you can also change the duration that your Microsoft Excel app is shown for, currently set as 2:00 for two minutes.

Frequently asked questions:

How often will the app pull in updates from the spreadsheet?

The app will auto-refresh and pull in new updates every five minutes.

How many results does it fetch (e.g. maximum number of content/posts)?

The app currently only supports displaying a single worksheet from a single Excel file. However, the range of data fetched from the sheet is fully customizable. You can display all used cells, or pick a smaller subset via the app configuration for “Cell Range”.

Can I select multiple sheet tabs to display and cycle through the app?

The app can’t support multiple tables being used, it is just one per app instance. You can add as many instances of the app as you’d like and select different sheet tabs to display for digital signage.

Can the app support charts, graphs, or any advanced formatting (e.g. colored cells)?

Currently, the app doesn’t support charts, graphs, or advanced formatting. However, our team will be working on this enhancement to be part of the app as it is further developed in the future.

How far do the results pull in (e.g. can it only fetch data within a specific time frame)?

There is no data fetch limit for the Microsoft Excel app.

How are the results ordered?

The Microsoft Excel app displays rows and columns in the same order as they are in the worksheet.

What zones is the app supported in?

The Microsoft Excel app supports both the main and sidebar zone layouts. It does not support the ticker tape zone.

Are there any character limits?

There is only a 25 character limit for the title created while configuring the app.

Does it support running offline?

Currently, the app does not support offline mode. However, our team will be working on this enhancement to be part of the app as it is further developed in the future.

Does it support preloading?

No, the app does not support preloading as our current players do not have this capability.

Does it support custom themes?

No, the app currently does not support custom themes.

For further questions, please contact with details.  

spreadsheetdatametricinformationanalyticsdigital signagedigital screenTV screen