MultiSheet Property (XlsExport)

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
C#

'Declaration
 
Public Property MultiSheet As System.Boolean

public System.bool MultiSheet {get; set;}

Property Value

Boolean. The default value is False.

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.

Example

GrapeCity.ActiveReports.Export.Excel.Section.XlsExport docexp = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
docexp.AutoRowHeight = true;
docexp.DisplayGridLines = true;
docexp.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95; //or Xls97Plus or Xlsx
docexp.MinColumnWidth = 3;
docexp.MinRowHeight = 1;
docexp.MultiSheet = true;
docexp.RemoveVerticalSpace = true;
docexp.UseCellMerging = false;
docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");

Visual Basic

Dim docexp As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
docexp.AutoRowHeight=True
docexp.DisplayGridLines=True
docexp.FileFormat=GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95 'Or Xls97Plus
docexp.MinColumnWidth=3
docexp.MinRowHeight=1
docexp.MultiSheet=True
docexp.RemoveVerticalSpace=True
docexp.UseCellMerging=False
docexp.Export(Me.viewer1.Document, Application.StartupPath + "\x.xls")

Reference

XlsExport Class
XlsExport Members