spreadsheet alternative?

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I want to be able to display a spreadsheet exactly as formatted (either Google Spreadsheet or Excel).  Using the Google Spreadsheet Widget, we see that it is stripping out the formatting that we have created and is using only the formatting within the widget.  Does anyone have any ideas of how to show a spreadsheet but also show the original formatting?  We want to create an easy process for certain users to be able to update a spreadsheet on their computer and then the changes are reflected on the digital signage.
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
sheets to html converter
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb
Thanks.  Can you go into a little more detail?  Is there a way to do this automatically whenever edits are made, or what?  Also, where in the Google spectrum would we be able to store it and have it be available to use via the Web Page Widget?
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
There was no need for me to use anything like that, so I do not know specifics. But, man, I would love to learn from you if you came across something useful.
Photo of Shea

Shea, Official Rep

  • 5,188 Points 5k badge 2x thumb
Hi Joshua, 

I just setup a test Spreadsheet here and published it to the web then embedded it in the webpage widget at 1920x1080, this is what the end result was:

http://preview.risevision.com/?type=presentation&id=a890bc9a-4c66-41cd-9ce6-3e113c460bfa&sho...

Looks like most formatting is carried over. Let me know if this works for you. 

Thanks,
Shea 
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb
Thanks Shea.  Let me give that a try.
Photo of Mike Thomas

Mike Thomas

  • 1,282 Points 1k badge 2x thumb
Hello Joshua,

Did you have any success with Shea's suggestion?

Regards,
Mike Thomas
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb
Hi Mike.  I tried it and saw some things that I didn't like (it shows the spreadsheet name and tab name at the top and there is a Google footer at the bottom).  I have not had time today to see if this is something that I can disable, and was going to try to look into it more tomorrow.  Otherwise, this looks to be a fine option for the spreadsheets where we want to keep our formatting.
(Edited)
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
That would be 'Region' settings. Iframe actually would be the best way to deal with this, but if u insist... Giving that you spreadsheet is a web page, you need to know exact or as close as possible dimensions of the desirable and not so much elements in the webpage. Based on that you make you placeholder just enough to show the desired area in the webpage. Then inset the widget and link to the sheets webpage. After that, use Region settings to 'scroll' the page horizontally and vertically the way only desired area is visible.

Alternatively, you can dumb it all down and slap additional placeholders with content (color, images or widgets) on top of the placeholder with spreadsheet and cover all what needs to be covered.
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb
Thanks. That makes sense. I might try that if the header and footer really start to bother people.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Joshua, simply put another empty placeholder over header and footer with the background color matching the rest of webpage.
Photo of Joshua

Joshua

  • 150 Points 100 badge 2x thumb
I went a different route.  I made the Placeholder slightly bigger than the display.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
whatever works )))
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
DataTables is an amazing tool that can easily be integrated with Google Sheets. If you use WordPress on your website, there is actually a FREE plugin you can download that you connect to your Google Account and authorize to access your spreadsheet, which gives you the same effect as RiseVision's gadget, but with MUCH LESS overhead and page speed degradation... 

Here is a FREE one that I use personally, if you know how to use the queries, you can do a lot of easy customization: https://wordpress.org/plugins/inline-google-spreadsheet-viewer/

Here is a paid version, one time $44 fee that is fairly robust: https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-sprea...