ActiveReports 8
MinRowHeight Property
See Also  Example
GrapeCity.ActiveReports.Export.Excel.v8 Assembly > GrapeCity.ActiveReports.Export.Excel.Section Namespace > XlsExport Class : MinRowHeight Property

Glossary Item Box

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

Visual Basic (Declaration) 
Public Property MinRowHeight As System.Single
C# 
public System.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

Visual BasicCopy 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")
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");

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also