How to: Programmatically Display a String in a Worksheet Cell
This example demonstrates how to display text in a cell programmatically. To display text in cell, use either a NamedRange control or a native Excel range object.
Applies to: The information in this topic applies to document-level projects and VSTO add-in projects for Excel. For more information, see Features Available by Office Application and Project Type.
This example uses a NamedRange control named
message. The control must be added to a document-level customization at design time. The following code must be placed in a sheet class, not in the
Set the value of the NamedRange control to Hello World.
The following code creates a new range programmatically and then assigns a value to it.
Retrieve the range at cell A1 on
Sheet1and set the value to Hello World.