バージョン

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>
参照