ActiveReports 11
UseCellMerging Property
Example 

GrapeCity.ActiveReports.Export.Excel.v11 Assembly > GrapeCity.ActiveReports.Export.Excel.Section Namespace > XlsExport Class : UseCellMerging Property
Sets or returns a value indicating whether cells should be merged together where applicable.
Syntax
'Declaration
 
Public Property UseCellMerging As Boolean
public bool UseCellMerging {get; set;}

Property Value

Boolean.  The default value is False.
Remarks
Since Excel95 does not support cell merging this property is not applicable when Version is set to Excel 95.
Example
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")
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");
See Also

Reference

XlsExport Class
XlsExport Members