Extract Part of an Excel Spreadcheat into a Nightbot Command

Asked Jan 7, 2025·2 replies·Last activity 1 year ago·Open in Discord ↗
Archived from the original community forum
Things may have changed since it was written. Still stuck? Ask the community on Discord.

As I mentioned in the title, I want to extract the values of certain cells(prob just one) from my Excel spreadsheet and then use it inside of a Nightbot command. The issue is that I don’t want to use Python because multiple people edit the file. Do you think it’s possible to achieve this?

2 replies

I don't believe you would be able to condense this operation to be small enough to fit within a Nightbot command. You may need to build an external API that Nightbot is able to load it from instead.

I made a makeshift API that you can host on your own to convert data to json that can be sliced accordingly
Sheet XL api