spreadsheet alternative?

Comments

15 comments

  • Avatar
    Darius Aleksas
    sheets to html converter
  • Avatar
    Joshua
    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?
  • Avatar
    Darius Aleksas
    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.
  • Avatar
    Shea Darlison
    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 
  • Avatar
    Joshua
    Thanks Shea.  Let me give that a try.
  • Avatar
    Mike Thomas
    Hello Joshua,

    Did you have any success with Shea's suggestion?

    Regards,
    Mike Thomas
  • Avatar
    Joshua
    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.
  • Avatar
    Darius Aleksas
    You can hide all that using Web Page Widget and/or iframe.
  • Avatar
    Joshua
    Hi Darius.  I'm not seeing checkboxes in the Web Page Widget to try to hide that kind of stuff.  Where are you making these changes?  I'd rather try to avoid creating an iframe.
  • Avatar
    Darius Aleksas
    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.
  • Avatar
    Joshua
    Thanks. That makes sense. I might try that if the header and footer really start to bother people.
  • Avatar
    Darius Aleksas
    Joshua, simply put another empty placeholder over header and footer with the background color matching the rest of webpage.
  • Avatar
    Joshua
    I went a different route.  I made the Placeholder slightly bigger than the display.
  • Avatar
    Darius Aleksas
    whatever works )))
  • Avatar
    Matthew Trigg
    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...

Please sign in to leave a comment.