Skip to content

Standalone v1

Choose a tag to compare

@GrandyB GrandyB released this 11 Oct 17:02
· 24 commits to master since this release

First release of the standalone/remote version of SheetToHTML.

Installation

  • Download and unzip somewhere
  • Open the html file in your notepad of choice and add in your Google Sheets API Key

Preparation

  • View the templates list - there's images in each folder to get a sense of layout
  • Head to the Data Template Sheet and copy the tab corresponding to the template you chose
  • Create a new spreadsheet, put the data template you copied into a tab, and name that tab appropriately to your use case
  • (Optional) Create a background image that matches the template layout to give it some fancy theme if you want to, put it in a cell on your tab and remember which cell it is
  • Choose a font from the Google Fonts library
  • Set the sharing settings on your spreadsheet to "anyone with the link can view"

Usage

  • Use a browser source, and point it at your html file, e.g.
    file:///F:/Projects/SheetToHTML/standalone/graphic-remote.html?id=1oyCe0dcpL5-Lg1SCwJRIePqITLxJAf29VZ-VXx-v5Mc&tab=bracket-8player&imgCell=B20&font=Bellefair&template=bracket-8player

Parameters

  • “id” = Spreadsheet ID, e.g. 1oyCe0dcpL5-Lg1SCwJRIePqITLxJAf29VZ-VXx-v5Mc
  • “tab” = Tab name, e.g. GroupA
  • “imgCell” = (optional) cell reference that contains background image URL - e.g. &imgCell=B20
    • Example image URL (found in B20): https://i.imgur.com/qV15iF4.png
  • “font” = Google Font name from https://fonts.google.com/ - e.g. &font=Young%20Serif
  • “color” = (optional) text color, hex without # - e.g. &color=FF0000 (red)
  • “template” = Folder name - e.g. &template=bracket-8player
  • “update” = (optional) automatic data updating