How to: Programmatically display a string in a worksheet cell

  • [アーティクル]

Applies to: yesVisual Studio noVisual Studio for Mac

Note

This article applies to Visual Studio 2017. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here

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.

Use a NamedRange control

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 ThisWorkbook class.

To display text in a NamedRange control

  1. Set the value of the NamedRange control to Hello World.

    this.message.Value2 = "Hello world";

    Me.message.Value2 = "Hello world"

Use a native Excel range

The following code creates a new range programmatically and then assigns a value to it.

To display text in an Excel range

  1. Retrieve the range at cell A1 on Sheet1 and set the value to Hello World.

    Excel.Range rng = Globals.Sheet1.Range["A1"];
rng.Value2 = "Hello world";

    Dim rng As Excel.Range = Globals.Sheet1.Range("A1")
rng.Value2 = "Hello world"

See also