For definitions of each of these properties, see Style . The following example demonstrates defining a format for a cell. Formula Use Formula to add Microsoft Excel formulas to your spreadsheet. For a complete list of available formulas see Formula Functions . The following example demonstrates using a formula.
Name Returns the specified cell's name.
A cell name includes its column letter and row number, for example B5. To retrieve the name of a cell, use, cell.name PutValue Puts a value in a cell. The following example demonstrates setting a cell object, and retrieving its row number. Both Format and Style define the look of cells, but a format is created for a single cell, while a style is defined for reuse. Define a format for a single cell, rather than create a style, only if it is unlikely that you will apply the same format to other cells.