バージョン

SetExcelGroupFormatSettings メソッド

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

パラメータ

d
value
使用例
Dim groupFormatSettings As New FormatSettings() 
groupFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double
groupFormatSettings.BottomBorderColor = Colors.Red 
groupFormatSettings.FontStrikeout = Infragistics.Excel.ExcelDefaultableBoolean.True
groupFormatSettings.FontStyle = FontStyles.Italic 
groupFormatSettings.FontUnderlineStyle = Infragistics.Excel.FontUnderlineStyle.Double
groupFormatSettings.LeftBorderColor = Colors.Green 
groupFormatSettings.RightBorderColor = Colors.Blue 
groupFormatSettings.TopBorderColor = Colors.Purple 
groupFormatSettings.VerticalAlignment = Infragistics.Excel.VerticalCellAlignment.Center 

DataPresenterExcelExporter.SetExcelGroupFormatSettings(Me.Grid.FieldSettings, groupFormatSettings)
FormatSettings groupFormatSettings = new FormatSettings();
groupFormatSettings.BorderStyle = Infragistics.Excel.CellBorderLineStyle.Double;
groupFormatSettings.BottomBorderColor = Colors.Red;
groupFormatSettings.FontStrikeout = Infragistics.Excel.ExcelDefaultableBoolean.True;
groupFormatSettings.FontStyle = FontStyles.Italic;
groupFormatSettings.FontUnderlineStyle = Infragistics.Excel.FontUnderlineStyle.Double;
groupFormatSettings.LeftBorderColor = Colors.Green;
groupFormatSettings.RightBorderColor = Colors.Blue;
groupFormatSettings.TopBorderColor = Colors.Purple;
groupFormatSettings.VerticalAlignment = Infragistics.Excel.VerticalCellAlignment.Center;

DataPresenterExcelExporter.SetExcelGroupFormatSettings(this.Grid.FieldSettings, groupFormatSettings);
<igDP:XamDataGrid.FieldSettings>
    
<igDP:FieldSettings>
        
<igExcelExporter:DataPresenterExcelExporter.ExcelGroupFormatSettings>
            
<igExcelExporter:FormatSettings 
                
BorderStyle="Double"
                
BottomBorderColor="Red"
                
FontStrikeout="True"
                
FontStyle="Italic"
                
FontUnderlineStyle="Double"
                
LeftBorderColor="Green"
                
RightBorderColor="Blue"
                
TopBorderColor="Purple"
                
VerticalAlignment="Center" />            
        
</igExcelExporter:DataPresenterExcelExporter.ExcelGroupFormatSettings>
    
</igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>
参照