Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property MultiSheet As System.Boolean | |
| C# | |
|---|---|
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
| C# |  Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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") | |