def cell_add(self, cell, value=None):
"""
Adds a cell to the Spreadsheet. Either the cell argument can be specified, or any combination of the other
arguments.
:param address: the address of the cell
:param cell: a Cell object to add
:param value: (optional) a new value for the cell. In this case, the first argument cell is processed as
an address.
:param formula:
"""
if type(cell) != Cell:
cell = Cell(cell,
None,
value=value,
formula=None,
is_range=False,
is_named_range=False)
addr = cell.address()
if addr in self.cellmap:
raise Exception('Cell %s already in cellmap' % addr)
cellmap, G = graph_from_seeds([cell], self)
self.cellmap = cellmap
self.G = G
print(
"Graph construction updated, %s nodes, %s edges, %s cellmap entries"
% (len(G.nodes()), len(G.edges()), len(cellmap)))
def add_cell(self, cell, value = None):
if type(cell) != Cell:
cell = Cell(cell, None, value = value, formula = None, is_range = False, is_named_range = False)
addr = cell.address()
if addr in self.cellmap:
raise Exception('Cell %s already in cellmap' % addr)
cellmap, G = graph_from_seeds([cell], self)
self.cellmap = cellmap
self.G = G
print "Graph construction updated, %s nodes, %s edges, %s cellmap entries" % (len(G.nodes()),len(G.edges()),len(cellmap))
def add_cell(self, cell, value=None):
if type(cell) != Cell:
cell = Cell(cell,
None,
value=value,
formula=None,
is_range=False,
is_named_range=False)
addr = cell.address()
if addr in self.cellmap:
raise Exception('Cell %s already in cellmap' % addr)
cellmap, G = graph_from_seeds([cell], self)
self.cellmap = cellmap
self.G = G
print "Graph construction updated, %s nodes, %s edges, %s cellmap entries" % (
len(G.nodes()), len(G.edges()), len(cellmap))
