Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{description}
{excerpt}Sets or returns the name of the worksheet.  Sheet names are limited to 255 characters and must not contain the following characters: \ / \? \[ \] : '{excerpt}
{signature:C#}
 public System.String Name{ get; set; }
{signature}{signature:vb.net}
Public Property Name() As String
{signature}
{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.
{remarks}
{example}{code:csharp|title=C#}

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

          //--- Set SheetName
          ws.Name = "SheetOne";
        {code}
{code:vb.net|title=vb.net}

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

          '--- Set SheetName
          ws.Name = "SheetOne"
        {code}

{example}