Sets or returns a value in inches indicating how small columns can be in the Excel document. Larger values reduce number of columns in a sheet.

Syntax

Visual Basic (Declaration)
Public Property MinColumnWidth As Single

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

C#
public float MinColumnWidth {get; set;}

Return Value

Single. The default value is 0.1.

Example

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

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")`

Remarks

This is typically the single most important variable to tweak when exporting to Excel.

ActiveReports.XlsExport	Request technical support
MinColumnWidth Property
See Also Example

Syntax

Return Value

Example

Remarks

See Also

Reference