GrapeCity.Xaml.Excel
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 Short, _
   ByVal baseColumnWidth As Double, _
   ByVal defaultColumnWidth As Nullable(Of Double) _
) 
'Usage
 
Dim instance As IExcelReader
Dim sheet As Short
Dim baseColumnWidth As Double
Dim defaultColumnWidth As Nullable(Of Double)
 
instance.SetDefaultColumnWidth(sheet, baseColumnWidth, defaultColumnWidth)
void SetDefaultColumnWidth( 
   short sheet,
   double baseColumnWidth,
   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