Mini Excel, CSV, Google Sheet viewer (DEMO)
· v1.9
About
All my apps are completely free and I work on them during my free time. A small donation in the value of a virtual coffee (about 2$) and an honest opinion would mean so much to me.
Support me at: buymeacoffee.com/frogec
List of functionalities:
- Display Excel, CSV, Odf as JPG image from url.
Settings:.
- Set url, itable size and image position
HOW THE APP WORKS:
The application uses "makeImageRequest" function to retrieve image from url. Details at https://developer.garmin.com/connect-iq/api-docs/Toybox/Communications.html#makeImageRequest-instance_function. The url in this case is a web service which converts spreadsheet into JPEG image. Currently the application allows to set the "url" address (The URL of an image to request) and also 'maxWidth' (The maximum width an image should be scaled to) and 'maxHeight' (The maximum height an image should be scaled to) parameters.
After the image is retrieved from the 'url'/website address it is stored locally and drawn on the location 'x' (The top left x coordinate to begin the draw) and 'y' (he top left y coordinate to begin the draw) on the watchface. Details at https://developer.garmin.com/connect-iq/api-docs/Toybox/Graphics/Dc.html#drawBitmap-instance_function.
Currently the widget stores the last picture that you requested.
The application cannot automatically refresh picture in the background due to Garmin platform limitations.
Google Sheets:
1.Create new spreadsheet in google docs (not google drive)
2.Google sheet url must be public and exported as CSV. To do that URL has to be modified to export sheet as CSV.
Technical details:https://towardsdatascience.com/read-data-from-google-sheets-into-pandas-without-the-google-sheets-api-5c468536550
Change it from:
https://docs.google.com/spreadsheets/d/1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRByQ/edit#gid={googleId}
To:
https://docs.google.com/spreadsheets/d/1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRByQ/export?format=csv&gid={googleId}
Example:
https://docs.google.com/spreadsheets/d/1Yui2LuxoJQi61zYj5p_jjfsOoePNYeT2/export?format=csv&gid=765411898
Super hacky, it may break, but it works on few of my test cases.
Scrolling text:
Copyright 2017 by HarryOnline
https://creativecommons.org/licenses/by/4.0/
https://gitlab.com/harryonline/fortune-quote/-/blob/master/source/
What's new
Performance tweaks
Thank you for your feedback!