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

Versions Compared

Old Version 6

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

Saved on

compared with

New Version 7

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

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

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; }
{signature}{signature:</pre></td></tr></tbody></table>
} Public
Signature
vb.net
vb.net

<p>Public Property Name() As String
{signature}
{remarks}
If you change a String</p>
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#}

Example
Code Block
csharp
csharp
titleC#


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

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


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

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

{example}