バージョン

SetExcelCellFormatSettings メソッド

'ExcelCellFormatSettings' 添付プロパティの値を設定します。
シンタックス
'宣言
 
Public Shared Sub SetExcelCellFormatSettings( _
   ByVal d As DependencyObject, _
   ByVal value As FormatSettings _
) 
public static void SetExcelCellFormatSettings( 
   DependencyObject d,
   FormatSettings value
)

パラメータ

d
value
使用例
Dim cellFormatSettings As New FormatSettings() 
cellFormatSettings.BorderColor = Colors.Blue 
cellFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double 
cellFormatSettings.FillPattern = Infragistics.Excel.FillPatternStyle.DiagonalStripe
cellFormatSettings.FillPatternForegroundColor = Colors.White 
cellFormatSettings.FillPatternBackgroundColor = Colors.Black 
cellFormatSettings.FontColor = Colors.Red 
cellFormatSettings.FontFamily = New FontFamily("Times New Roman") 
cellFormatSettings.FontSize = New Infragistics.Windows.DeviceUnitLength(14, Infragistics.Windows.DeviceUnitType.Point) 
cellFormatSettings.FontWeight = FontWeights.Bold 
cellFormatSettings.HorizontalAlignment = Infragistics.Excel.HorizontalCellAlignment.Center 

DataPresenterExcelExporter.SetExcelCellFormatSettings(Me.Grid.FieldSettings, cellFormatSettings)
FormatSettings cellFormatSettings = new FormatSettings();
cellFormatSettings.BorderColor = Colors.Blue;
cellFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double;
cellFormatSettings.FillPattern = Infragistics.Excel.FillPatternStyle.DiagonalStripe;
cellFormatSettings.FillPatternForegroundColor = Colors.White;
cellFormatSettings.FillPatternBackgroundColor = Colors.Black;
cellFormatSettings.FontColor = Colors.Red;
cellFormatSettings.FontFamily = new FontFamily("Times New Roman");
cellFormatSettings.FontSize = new Infragistics.Windows.DeviceUnitLength(14, Infragistics.Windows.DeviceUnitType.Point);
cellFormatSettings.FontWeight = FontWeights.Bold;
cellFormatSettings.HorizontalAlignment = Infragistics.Excel.HorizontalCellAlignment.Center;

DataPresenterExcelExporter.SetExcelCellFormatSettings(this.Grid.FieldSettings, cellFormatSettings);
<igDP:XamDataGrid.FieldSettings>
    
<igDP:FieldSettings>
        
<igExcelExporter:DataPresenterExcelExporter.ExcelCellFormatSettings>
            
<igExcelExporter:FormatSettings 
                
BorderColor="Blue"
                
BorderStyle="Double"
                
FillPatternForegroundColor="White" 
                
FillPatternBackgroundColor="Black"
                
FillPattern="DiagonalStripe"
                
FontColor="Red"
                
FontFamily="Times New Roman"
                
FontWeight="Bold"
                
HorizontalAlignment="Center">
                
<igExcelExporter:FormatSettings.FontSize>
                    
<igWindows:DeviceUnitLength UnitType="Point" Value="14" />
                
</igExcelExporter:FormatSettings.FontSize>
            
</igExcelExporter:FormatSettings>
        
</igExcelExporter:DataPresenterExcelExporter.ExcelCellFormatSettings>
    
</igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>
参照