A python library for reading and writing Gnumeric files.
Open an existing workbook and explore what's available:
from gnumeric.workbook import Workbook
wb = Workbook.load_workbook('samples/test.gnumeric')
# Get the active sheet
ws = wb.get_active_sheet() # can also use wb.active
# Get a sheet by name
ws_1 = wb.get_sheet_by_name('Sheet1')
# Get cell at A1
cell_a1 = ws['A1']
cell_a1 = ws[(0, 0)] # zero-indexed (row, column)
# Get the value in the cell
cell_a1.get_value()
Currently, this library does not support:
- Evaluating expressions
- Graphs