ActiveReports 14
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.ActiveReports.Export.Excel.Section Namespace / XlsExport Class / UseCellMerging Property
Example

In This Topic
    UseCellMerging Property
    In This Topic
    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