if __name__ == "__main__": document = Document('spreadsheet') body = document.body table = Table("First Table") body.append(table) # populate the table : for i in range(10): table.set_value((1, i), (i + 1)**2) table.set_value("A11", "Total:") # lets define a named range for the 10 values : crange = "B1:B10" name = "squares_values" table_name = table.name table.set_named_range(name, crange, table_name) # we can define a single cell range, using notation "B11" or (1, 10) : table.set_named_range('total', (1, 10), table_name) # get named range values : values = table.get_named_range('squares_values').get_values(flat=True) # set named range value : result = sum(values) table.get_named_range('total').set_value(result) # lets use the named ranges from a second table : table2 = Table("Second Table") body.append(table2)
if __name__ == "__main__": document = Document("spreadsheet") body = document.body table = Table("First Table") body.append(table) # populate the table : for i in range(10): table.set_value((1, i), (i + 1)**2) table.set_value("A11", "Total:") # lets define a named range for the 10 values : crange = "B1:B10" name = "squares_values" table_name = table.name table.set_named_range(name, crange, table_name) # we can define a single cell range, using notation "B11" or (1, 10) : table.set_named_range("total", (1, 10), table_name) # get named range values : values = table.get_named_range("squares_values").get_values(flat=True) # set named range value : result = sum(values) table.get_named_range("total").set_value(result) # lets use the named ranges from a second table : table2 = Table("Second Table") body.append(table2)