Spread WPF Documentation
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)}
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

IExcelReader Interface
IExcelReader Members

 

 


Copyright © GrapeCity, inc. All rights reserved.