Spread WPF Documentation
SetDefaultColumnWidth Method


GrapeCity.Excel Namespace > IExcelReader Interface : SetDefaultColumnWidth Method
The zero based sheet index used to locate the IExcelWorksheet instance
Specifies the number of characters of the maximum digit width of the normal style's font This value does not include margin padding or extra padding for gridlines. It is only the number of characters.
Default column width measured as the number of characters of the maximum digit width of the normal style's font.
Set the default column width
Syntax
'Declaration
 
Sub SetDefaultColumnWidth( _
   ByVal sheet As System.Short, _
   ByVal baseColumnWidth As System.Double, _
   ByVal defaultColumnWidth As System.Nullable(Of Double) _
) 
'Usage
 
Dim instance As IExcelReader
Dim sheet As System.Short
Dim baseColumnWidth As System.Double
Dim defaultColumnWidth As System.Nullable(Of Double)
 
instance.SetDefaultColumnWidth(sheet, baseColumnWidth, defaultColumnWidth)
void SetDefaultColumnWidth( 
   System.short sheet,
   System.double baseColumnWidth,
   System.Nullable<double> defaultColumnWidth
)

Parameters

sheet
The zero based sheet index used to locate the IExcelWorksheet instance
baseColumnWidth
Specifies the number of characters of the maximum digit width of the normal style's font This value does not include margin padding or extra padding for gridlines. It is only the number of characters.
defaultColumnWidth
Default column width measured as the number of characters of the maximum digit width of the normal style's font.
Remarks
If the defaultColumnWidth has not value set. it can be calculated: defaultColumnWidth = baseColumnWidth + {margin padding (2 pixels on each side)} + {gridline(1 pixel)}
See Also

Reference

IExcelReader Interface
IExcelReader Members