Page tree

Versions Compared

Key

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

Excerpt

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

Signature
C#C#
Wiki Markup
{description}
{excerpt}Sets whether ExcelWriter should remove template macros from the generated spreadsheet or include them. 
{excerpt}
{signature:C#}
 public boolean ExcludeMacros{ get; set; }
Signature
{signature}
{signature:vb.net
vb.net
}
Public Property ExcludeMacros() As Boolean
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.

{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#}

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

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

{example}
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle