How to use Microsoft Excel Online with OptiSigns

Microsoft Excel is a very popular ways to create and share your spreadsheet. You can also use it on your Digital Signage screen.

 

There are 2 ways to use Excel with OptiSigns

1) Just upload the XLSX file, and OptiSigns will convert and display on your screen (pros: can play offline, just upload files, cons: when there are changes, you need to upload the files again)

2) Use Excel for Web (online) (pros: you can make changes to the Excel file and screens will update automatically, cons: need internet connection to display)

 

This article will walk you through how to set up option 2:

Upload your Excel to OneDrive and changes to your Excel can be automatically updated on your screens.

blobid2.png

If this is the first time you use OptiSigns, you can read here to get set up.

Otherwise, let's dive in.

1) Create and prepare your Excel

First, create or upload your Exel file to your Microsoft OneDrive and Open it.

mceclip0.png

Then on the File tab of the Ribbon, click Share, and then click Embed.

blobid3.png

To create the HTML code to embed your file in the web page, click Generate

Under Embed Code, right-click the code, click Copy, and then click Close.

blobid4.png

 

2) Add Excel Online App on OptiSigns

Go to our portal: https://app.optisigns.com

Click File/Assets, then click Apps, search and select Excel Online app.
blobid0.png

Then edit the Excel Online's info.

blobid1.png

Name: for you to remember, you can use the same Excel file name.
Embed: Paste in your Embed Code.
Update Interval: default is 600 seconds (10 minutes). This mean the app will refresh the link every 10 mins for any changes in your speadsheet.

Sign in: If you want to keep your Excel private and requires login password to display it.
Username: Enter your Microsoft username.
Password: Enter your Microsoft password.

Click Save

That's it, you have created a Excel Online.
Anytime changes made to the Excel Online workbook, the screens will be updated by the update intervals.

If you have any additional questions, concerns or any feedback about OptiSigns, feel free to reach out to our support team at support@optisigns.com or just submit a ticket here.

 

 

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Article is closed for comments.