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 Single

Visual Basic (Usage)	Copy Code
`Dim instance As XlsExport Dim value As Single instance.MinRowHeight = value value = instance.MinRowHeight`

C#
public float MinRowHeight {get; set;}

Return Value

Single. The default value is 0.1.

Example

Visual Basic	Copy Code
`Dim docexp As New DataDynamics.ActiveReports.Export.Xls.ExcelExport() docexp.AutoRowHeight=True docexp.DisplayGridLines=True docexp.FileFormat=Xls95 'Or Xls97Plus docexp.MinColumnWidth=360 docexp.MinRowHeight=250 docexp.MultiSheet=True docexp.RemoveVerticalSpace=True docexp.UseCellMerging=False docexp.Export(Me.viewer1.Document, Application.StartupPath + "\\x.xls")`

C# Copy Code

C#	Copy Code
`DataDynamics.ActiveReports.Export.Xls.XlsExport docexp = new DataDynamics.ActiveReports.Export.Xls.ExcelExport(); docexp.AutoRowHeight=true; docexp.DisplayGridLines=true; docexp.FileFormat=Xls95; //or Xls97Plus docexp.MinColumnWidth=360; docexp.MinRowHeight=250; docexp.MultiSheet=true; docexp.RemoveVerticalSpace=true; docexp.UseCellMerging=false; docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");`

DataDynamics.ActiveReports.Export.Xls.XlsExport docexp = new DataDynamics.ActiveReports.Export.Xls.ExcelExport();

docexp.AutoRowHeight=true;

docexp.DisplayGridLines=true;

docexp.FileFormat=Xls95; //or Xls97Plus
docexp.MinColumnWidth=360;

docexp.MinRowHeight=250;

docexp.MultiSheet=true;

docexp.RemoveVerticalSpace=true;

docexp.UseCellMerging=false;

docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");

ActiveReports.XlsExport	Request technical support
MinRowHeight Property
See Also Example

Syntax

Return Value

Example

See Also

Reference