バージョン

SetExcelSummaryLabelFormatSettings メソッド

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

パラメータ

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

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

DataPresenterExcelExporter.SetExcelLabelFormatSettings(this.Grid.FieldSettings, labelFormatSettings);
<igDP:XamDataGrid.FieldSettings>
    
<igDP:FieldSettings>
        
<igExcelExporter:DataPresenterExcelExporter.ExcelLabelFormatSettings>
            
<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.ExcelLabelFormatSettings>
    
</igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>
参照