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") sheet.cell_set_text(0,4,"zzz") sheet.cell_set_value(0,5,Gnm.Value.new_string("abc")) sheet.cell_set_value(0,6,Gnm.Value.new_bool(1)) # Copy A1:A7, paste to C1:C7 src = Gnm.Range() src.init(0,0,0,6) cr = Gnm.clipboard_copy_range(sheet,src) dst = Gnm.Range() dst.init(2,0,2,6) pt = Gnm.PasteTarget.new (sheet,dst,Gnm.PasteFlags.DEFAULT) Gnm.clipboard_paste_region(cr,pt,None) # Make A1:A2 bold st = Gnm.Style.new() st.set_font_bold(1) r = Gnm.Range() r.init(0,0,0,1) sheet.apply_style(r,st) # Set a format for A2 st = Gnm.Style.new()