Sets or returns a value indicating whether each page is to be exported to its own sheet. True indicates that each page in the ActiveReports document will be exported to a separate sheet.

Syntax

Visual Basic (Declaration)
Public Property MultiSheet As Boolean

Visual Basic (Usage)	Copy Code
`Dim instance As XlsExport Dim value As Boolean instance.MultiSheet = value value = instance.MultiSheet`

C#
public bool MultiSheet {get; set;}

Return Value

Boolean. The default value is False.

Example

C#	Copy Code
`private void btnExport_Click(object sender, System.EventArgs e) { ActiveReport1 rpt = new ActiveReport1(); DataDynamics.ActiveReports.Export.Xls.XlsExport x = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); rpt.Run(); this.arv.Document = rpt.Document; x.MultiSheet = true; x.Export(rpt.Document, Application.StartupPath + "\\export.xls"); }`

Visual Basic	Copy Code
`Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim rpt As New ActiveReport1 Dim x As New DataDynamics.ActiveReports.Export.Xls.XlsExport rpt.Run() Me.arv.Document = rpt.Document x.MultiSheet = True x.Export(rpt.Document, Application.StartupPath & "\export.xls") End Sub`

Remarks

Setting this value to True can often increase performance and output quality at the cost of memory consumption up to a certain number of pages. The more complex the pages and the more deviation between page layouts in a single document, the lower the number of pages that should be exported to a single sheet. The complicity and deviation of layout between the pages drastically effects this number, but in general, a report with more than 30 pages would be a good candidate for setting this property to False.

ActiveReports.XlsExport	Request technical support
MultiSheet Property
See Also Example

Syntax

Return Value

Example

Remarks

See Also

Reference