OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 3

changes.mady.by.user Scott Dugas [softartisans]

Saved on

compared with

New Version 4

changes.mady.by.user Scott Dugas [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

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


{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}
Signature
C#C#
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}{signature:vb.net
vb.net
}
Public Property Name() As String
Remarks
If you change a 
{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.
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle