def gnm_init(): global cc global ioc # Initialize Gnm itself Gnm.init() # create a stderr reporting context cc = Gnm.CmdContextStderr.new() # Load plugins Gnm.plugins_init(cc) # A context for io operations ioc = GOffice.IOContext.new(cc) return ()
#!/usr/bin/python # ----------------------------------------------------------------------------- import gi gi.require_version('Gnm', '1.12') from gi.repository import Gnm Gnm.init() # A context for reporting errors to stderr cc = Gnm.CmdContextStderr.new() # Load plugins Gnm.plugins_init(cc) # ----------------------------------------------------------------------------- # Create a workbook with one sheet wb = Gnm.Workbook.new_with_sheets(1) # Get sheet. Index starts at 0 sheet = wb.sheet_by_index(0) print("Name: {}".format(sheet.props.name)) print("Number of columns: {}".format (sheet.props.columns)) print("Number of rows: {}".format (sheet.props.rows)) # Store values and expressions is some cells. Coordinates are (col,row) # both starting at 0. (So what the gui sees as row 1 is 0 here.) sheet.cell_set_value(0,0,Gnm.Value.new_int(10)) sheet.cell_set_value(0,1,Gnm.Value.new_float(101.25)) sheet.cell_set_text(0,2,"=A1+A2") sheet.cell_set_text(0,3,"'01")
import gi gi.require_version('Gnm', '1.12') gi.require_version('GOffice', '0.10') from gi.repository import Gnm from gi.repository import GOffice Gnm.init() import sys src_uri = GOffice.filename_to_uri (sys.argv[1]) dst_uri = GOffice.filename_to_uri (sys.argv[2]) # A context for reporting errors to stderr cc = Gnm.CmdContextStderr.new() # Load plugins Gnm.plugins_init(cc) # A context for io operations ioc = GOffice.IOContext.new (cc) # Read a file wbv = Gnm.WorkbookView.new_from_uri (src_uri, None, ioc, None) wb = wbv.props.workbook print("Loaded {}".format(wb.props.uri)) # Save a file fs = GOffice.FileSaver.for_file_name (dst_uri) if wbv.save_as (fs, dst_uri, cc): print("Saved {}".format(wb.props.uri)) else: print("Failed to save to {}".format(dst_uri))