Page History

Description

Excerpt
Sets or returns the name of the worksheet. Sheet names are limited to 255 characters and must not contain the following characters: \ / ? [ ] : '

Signature

	C#
	C#

<table class="diff-macro"><thead><tr><th class="diff-macro-title">unmigrated-wiki-markup</th></tr></thead><tbody><tr><td class="diff-macro-body"><pre>
 public System.String Name{ get; set; }
</pre></td></tr></tbody></table>

Signature

	vb.net
	vb.net

Public <p>Public Property Name() As String</p>String

Remarks
If you change a worksheet's name, any formulas that reference that worksheet will also be updated to use the new name. For example, if you have a formula "=Sheet1!A1", and you change Sheet1's name to "NewName", the formula will be updated to "=NewName!A1". If the formula did not reference a sheet name before the name change, it will not be affected.

Example

Code Block

	csharp
	csharp
title	C#

            //--- Get SheetName
          string sheetName = ws.Name;

          //--- Set SheetName
          ws.Name = "SheetOne";

Code Block

	vb.net
	vb.net
title	vb.net

            '--- Get SheetName
          Dim sheetName As String = ws.Name

          '--- Set SheetName
          ws.Name = "SheetOne"

Space Shortcuts

Page tree

Versions Compared

Old Version 46

New Version Current

Key