ActiveReports 18 .NET Edition
MESCIUS.ActiveReports.Export.Excel Assembly / GrapeCity.ActiveReports.Export.Excel.Section Namespace / XlsExport Class / MinRowHeight Property
Example

In This Topic
    MinRowHeight Property
    In This Topic

    Sets or returns a value in inches indicating the minimum height rows can be in the Excel document. Larger values force the export to place more controls on a single line by reducing the number of rows added to match blank space.

    Syntax
    'Declaration
 
Public Property MinRowHeight As Single
    public float MinRowHeight {get; set;}

    Property Value

    Single. The default value is 0.1.
    Remarks
    The MinRowHeight property takes effect only if the UseCellMerging property is set to True.
    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