ActiveReports 18 .NET Edition
MESCIUS.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

    Reference

    XlsExport Class
    XlsExport Members