gdods

Gdods is a small GDScript for reading ODS files: the OpenDocument format for
spreadsheets used in for example LibreOffice, and OpenOffice.

You can use this script to add support for ODS files to the game you’re
building in the Godot game engine. It does not support all features that ODS
files have, but sticks mainly to reading text and images from columns, and
providing you with some functions to iterate over spreadsheets.

Gdods uses gdunzip( https://github.com/jellehermsen/gdunzip ) under the hood,
for extracting the contents of the ODS file (since ODS files are actualy a
bunch of xml’s and other assets wrapped in a zip).

Example code
———————-
# Create a gdods instance
var gdods = load(‘res://addons/gdods/gdods.gd’).new()

# Load an ODS file
var loaded = gdods.load(‘res://test/test.ods’)

if !loaded:
print(‘Could not load ODS file :-(‘)
else:
# Get cell in sheet 0, row 2, column 1
# NB: numbering starts from 0
var cell = gdods.get_cell(0, 2, 1)

# Verify that the cell is a TextCell
if cell.type == gdods.TEXT_CELL:
print(‘We have a text cell with this value: ‘ + cell.value)

# Get another cell by using the named position
var cell2 = gdods.get_cell_by_name(‘A42’)

# Verify that this cell is an ImageCell
if cell2.type == gdods.IMAGE_CELL:
print(‘We have got us an image cell’)
# Grab the actual image from the ODS file
var image = cell2.load_image()
if !image:
print(‘Failed loading the image from the image cell’)
else:
print(‘Image width is: ‘ + str(image.get_width())

# Turn the second sheet with a header row into a array of dicts
var dictarray = gdods.to_dictarray(1, 0)

# Print the first row’s value for the ‘my_beautiful_key’ column
print(dictarray[0][‘my_beautiful_key’])

Class documentation
———————————

The gdods class inherits “reference”, and upon initialization it loads
gdunzip.gd from the same directory gdods.gd resides.

CONSTANTS:

– EMPTY_CELL = 0
– TEXT_CELL = 1
– IMAGE_CELL = 2

FUNCTIONS:

– bool load(String path)

Tries to load an ODS file with a given path. Returns false if it failed
loading the ods, or true if it was successfull.

– “Cell” get_cell(int sheet_nr, int row_nr, int column_nr)

Given a sheet number, row number and column number
this method will return this cell’s value, this
can either be a EmptyCell, TextCell or ImageCell instance.
If the cell can’t be found it will return an EmptyCell

NB: numbering starts at 0

– “Cell” get_cell_by_name(int sheet_nr, int pos)

Return a cell by giving its name (i.e A1, D100).
Returns an empty cell if the cell can’t be found, or if the input is incorrect.

– Array to_dictarray(int sheet_nr, int header_row)

If your sheet has a header row, you can use this function to transform all the
rows beneath the header row into a array of dicts. The header row will be used
as dictionary keys.
This function returns false if the sheet denoted by
sheet_nr or the header_row can’t be found.

INNER CLASSES

Gdods has 3 inner classes that are used for cell types: TextCell,
ImageCell, EmptyCell. Each of those has a to_string() function, and you can check the type
of the class by comparing the “type” attribute to one of the gdods’ constants
(EMPTY_CELL / TEXT_CELL / IMAGE_CELL).

You can get the image path from ImageCell by using the image_path
attribute, and you can load the image by calling the “load_image” function with
no arguments. This will return either false or an Image instance.