The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

SpreadsheetMailMergeOptions.UseTemplateSheetNames Property

Gets or sets a value indicating whether worksheet names in a merged document(s) should be generated based on the template worksheet's name.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

bool UseTemplateSheetNames { get; set; }
Property UseTemplateSheetNames As Boolean
bool UseTemplateSheetNames { get; set; }
Property UseTemplateSheetNames As Boolean
bool UseTemplateSheetNames { get; set; }
Property UseTemplateSheetNames As Boolean

Property Value

Type Description
Boolean

true, to use the template worksheet's name to name worksheets in the resulting document(s); otherwise, false.

Property Value

Type Description
Boolean

true, to use the template worksheet's name to name worksheets in the resulting document(s); otherwise, false.

Property Value

Type Description
Boolean

true, to use the template worksheet's name to name worksheets in the resulting document(s); otherwise, false.

Remarks

The following table demonstrates how the UseTemplateSheetNames property works depending on the selected mail merge mode (it is assumed that the template worksheet's name is set to TemplateSheet).

Mail Merge Mode

UseTemplateSheetNames = False

(Default)

UseTemplateSheetNames = True

Multiple Documents

The resulting worksheet name for each workbook is Sheet1.

The resulting worksheet name for each workbook is TemplateSheet.

Multiple Worksheets

The resulting worksheet names are Sheet1, Sheet2, ..., SheetN.

The resulting worksheet names are TemplateSheet1, TemplateSheet2, ..., TemplateSheetN.

Single Worksheet

The resulting worksheet name is Sheet1.

The resulting worksheet name is TemplateSheet.

See Also