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

...

Description

Excerpt

Sets whether ExcelWriter should remove template macros from the generated spreadsheet or include them.

Signature
C#
C#
 public boolean ExcludeMacros{ get; set; }
{signature}
{signature:
}
Signature
vb.net
vb.net
Public Property ExcludeMacros() As Boolean
{signature}
{remarks}
If [ExcludeMacros|ExcelTemplate.ExcludeMacros] is set to {{false}}, and the template spreadsheet contains macros, ExcelWriter will preserve the macros in the generated spreadsheet. If {{ExcludeMacros}} is set to {{true}}, and the template spreadsheet contains macros, ExcelWriter will not include the macros in the generated spreadsheet.  {{ExcludeMacros}} is set to {{false}} by default.

{{ExcludeMacros}} is a *Read/Write* property. 
{remarks}
{example}{code:csharp|title=C#}
Remarks

If ExcludeMacros is set to false, and the template spreadsheet contains macros, ExcelWriter will preserve the macros in the generated spreadsheet. If ExcludeMacros is set to true, and the template spreadsheet contains macros, ExcelWriter will not include the macros in the generated spreadsheet. ExcludeMacros is set to false by default.

ExcludeMacros is a Read/Write property.

Example
Code Block
csharp
csharp
titleC#


          //--- Setting SetExcludeMacros to "true" tells ExcelWriter to
          //--- to remove macros in the template from the generated
          //--- spreadsheet.
          xlt.ExcludeMacros = true;
        
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}


          '--- Setting SetExcludeMacros to "True" tells ExcelWriter to
          '--- to remove macros in the template from the generated
          '--- spreadsheet.
          xlt.ExcludeMacros = True
        
{code} {example}