Display Random text from a CSV or XLS Spreadsheet

SRQAZ13 · August 24, 2022, 7:47pm

Hi, I am not sure if something exits for this, but I have a spreadsheet that contains a list of text. If I wanted to display a random cell from this spreadsheet and have it displayed on the Tidbyt is that possible today or would need to be a newly coded app?

Thanks

pineapple · August 25, 2022, 8:08am

There is a csv reader, but I think you’d unfortunately have to copy paste that csv stuff into a.star file, but then you could just display it using render.Text or render.WrappedText

See the following link below and the encoding/csv.star link where the modules are listed. If running locally may be able to just pull in from a file name though. Check the readme or test.star file for this module itself though.

github.com

tidbyt/pixlet/blob/main/docs/modules.md

# Module reference

Pixlet scripts have access to a couple of modules that can be very
helpful in developing applets. To make use of a module, use the `load`
statement.

The example below would load the `render.star` Starlark module,
extract the `render` identifier and make it available to the script
as the symbol `render`.

```starlark
load("render.star", "render")
```

It's also possible to assign the identifiers to a different symbol. In
this example, the `render` module is made available to the script as
the symbol `r` instead of `render`:

```starlark
load("render.star", r = "render")

This file has been truncated. show original

AmillionAir · August 25, 2022, 11:32pm

I once tried to make an app that pulled info from Google sheets but holy mackerel Google makes interesting with their api complex so i kinda just gave up hahaha. It is possible though.

steingart · August 28, 2022, 9:34pm

@AmillionAir => the trick to using a google sheet for something like this

Make the sheet publically viewable in sharing
In the URL for the sheet, at the end of long/random string add /?format=csv

voila.

example:

(the sheet) test_sheet - Google Sheets

(the csv) https://docs.google.com/spreadsheets/d/1yKwcPBZH0mqFgn6MWeJgKCQhJvMZaaqh_jJ0pjNwPb8/export?format=csv