OpenIQ Devices
← Back

Mini Excel, CSV, Google Sheet viewer (DEMO)

· v1.9
★★★★★ (6) ↓ 1,000 downloads 2 Free

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!

Permissions

BackgroundCommunications

Details

Compatible with 233 devices
Updated Oct 24, 2023
Open on apps.garmin.com ↗